405 reputation
31635
bio website jakesee.com
location
age
visits member for 4 years, 1 month
seen Jan 17 at 14:50

Aug
13
comment Strange Excel IF formula evaluation
@DaveRook PMT is not the cell name, that box there is a dropdown listing the recently used functions.
Aug
13
comment Strange Excel IF formula evaluation
@DaveRook you can see from third screenshot from the top that editing the formula cell also highlights the G211 cell right above it. So, yea. its the correct worksheet, worksheet B. I mean, if you look at the evaluate formula dialogs, it says 0="APPLE" is TRUE! And yes, G211 when Evaluate, shows just a 0.
Aug
13
comment Strange Excel IF formula evaluation
@Indrek it's on Automatic already.
Aug
13
comment Strange Excel IF formula evaluation
@Indrek look at screenshots, freaking me out.
Aug
13
revised Strange Excel IF formula evaluation
added 79 characters in body
Aug
13
comment Strange Excel IF formula evaluation
@DaveRook No data validation or formatting, but i still click on "clear" just for good measures. Problem does not go away.
Aug
13
comment Strange Excel IF formula evaluation
@Indrek any string, e.g. "any string" will evaluate to true. False otherwise, unless of course you put a number 0.
Aug
13
comment Strange Excel IF formula evaluation
It happens in this workbook and all copies of it. I started a new workbook and cannot get the same behavior. There must be a setting I don't know. G211 is a manual 0, in fact, if i clear G211 (make it empty without any formatting), G212 still show 1.
Aug
13
revised Strange Excel IF formula evaluation
added 7 characters in body
Aug
13
comment Strange Excel IF formula evaluation
@Matteo the content of G211 is NOT a formula. It is a 0 manually entered. The desired return value in G212 should be 0.
Aug
13
comment Strange Excel IF formula evaluation
Cell A2 (G212) will show 1 when A1 (G211) is 0 or case-insensitive Apple e.g. aPpLe, ApPlE etc.
Aug
13
revised Strange Excel IF formula evaluation
added 109 characters in body
Aug
13
asked Strange Excel IF formula evaluation
Aug
6
awarded  Popular Question
Jul
27
awarded  Popular Question
Jul
21
awarded  Constituent
Jul
21
awarded  Caucus
Jul
10
answered Disable ability of web pages to turn off my context menu in IE
Jun
6
awarded  Popular Question
Jun
4
comment How to make network drives appear even if disconnected?
I'll try, but if the GPO for drives doesn't work, I doubt the logon scripts will work. Also the other issue is that some machines are laptops. I don't want the network drives to disappear. Ideally, they should stay in My Computer and when the user connects to VPN, the drive is accessible again.