Excel "if" Bug?
Are you sure D337 is blank? Click on D337 and then press the delete key.
Then press F9 to ensure calculation.
"BEEJAY" wrote in message
...
=IF(D337="Front",1,IF(D337="Rear",1,IF(D337="Both" ,2,0)))
Formula created on new, blank sheet - Works Great
Copy to Contract Sheets - Big Problems
Formula will not return a Zero, (as expected) when D337 is Blank
Checked cell formatting, etc. All the same as the OK Version.
If I select fx so that the function arguments screen pops up, the first
statement shows as TRUE (althought D337 is blank).
When I check fx on the original sheet, (with a blank D337), the first
statement correctly shows as false.
If I do a copy (from the non-working sheet) and insert onto a new, blank
ws,
the formula looks and works fine again.
Does anyone have any idea where I have to look for this one?
|