Oct 19 2018 12:28 PM
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
Oct 19 2018 04:11 PM
Oct 20 2018 09:22 AM
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.
Oct 22 2018 06:25 AM
Hi All,
I copied the worksheet to a new worksheet in the same workbook and it works correctly in the new worksheet. I deleted the original worksheet, no idea why it was not working as per IF, THEN, ELSE logic. Before I deleted the original worksheet, I overwrote the original worksheet with the cells from the new worksheet and still it did not work correctly.