Reputation
475
Top tag
Next privilege 500 Rep.
Access review queues
Badges
6 19 38
Impact
~278k people reached

  • 0 posts edited
  • 2 helpful flags
  • 12 votes cast
Sep
28
comment The requested security information is either unavailable or cannot be displayed
They are not in the NAS... not sure why. But one thing is for sure, the file cannot be copied to anywhere as it will generate the "file not found" error. The file might be a new file added after the mass copy-from-NAS.
Sep
28
asked The requested security information is either unavailable or cannot be displayed
Sep
18
awarded  Popular Question
Aug
20
accepted Strange Excel IF formula evaluation
Aug
14
awarded  Self-Learner
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.