380 reputation
31532
bio website jakesee.com
location Singapore, Singapore
age
visits member for 3 years, 9 months
seen Oct 18 at 13:04

Thinking


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.
Jun
4
comment How to make network drives appear even if disconnected?
For the folks I have here, anything beyond their comprehension is a hack. To them, it must work if I say it should. period. Anything else is my fault. So if they see the drives there showing the disconnected icon, they will believe is a Windows feature. If I tell them "please double click the network.bat if you don't see your drives" they will think is my fault that I am not setting up properly for them, causing them to have one more step to work after logging in.
Jun
4
asked How to make network drives appear even if disconnected?
May
7
accepted Change AD password when outside of LAN will prevent user windows log in?
May
3
asked Change AD password when outside of LAN will prevent user windows log in?