Excel "if" Bug?
try this...
=IF(trim(D337)="Front",1,IF(trim(D337)="Rear",1,IF (trim(D337)="Both",2,0)))
better still
=IF(or(trim(D337)="Front",trim(D337)="Rear"),1,IF( D337="Both",2,0))
--
HTH...
Jim Thomlinson
"BEEJAY" wrote:
=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?
|