Forum Discussion
SIMPLE Excel IF statement I have used for years not working
why does the formula =if($d10="X",1000,2000) give the same answer if d10 = X or is blank? When a numeric or alpha other than X is in D10, the answer is 2000
Scott, can you attach your file or a sample one with same issue?
In my tests, if D10 is X or x, I get 1000 and if D10 is blank or anything else but X, I get 2000.