386 reputation
21429
bio website jakesee.com
location Singapore, Singapore
age
visits member for 3 years, 8 months
seen Aug 25 at 5:44

Thinking


Aug
13
revised Strange Excel IF formula evaluation
edited tags
Aug
13
answered Strange Excel IF formula evaluation
Aug
13
comment Strange Excel IF formula evaluation
Thanks all, I got to leave my desk for now while I travell back home. Thank you all for actively following up and helping. Will get back with more updates if I can narrow down the issue some more.
Aug
13
revised Strange Excel IF formula evaluation
added 79 characters in body
Aug
13
comment Strange Excel IF formula evaluation
@Indrek it shows 1. Please see screenshot above.
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