Formula Question

O

oldjay

When I use the function arguments it says if(ID606="Y" is true when ID606 is
blank .WHY?

=IF(ID606="Y",1,2)
 
W

walrus

there must be something in your cell ID606 then...i just checked and i get
false and 2 for answers...
 
O

oldjay

I put a new formula =if(C1="Y",1.2) in A!. I get the same result. I even
deleted C1 just to be sure there was nothing in it. Now I added a new sheet
to this same workbook, put in the same formula and and got the correct
answers. What could be possible wrong with the original sheet to yield this
result?
 
J

Joe User

oldjay said:
When I use the function arguments it says
if(ID606="Y" is true when ID606 is blank .WHY?
=IF(ID606="Y",1,2)
Click to expand...

The only thing that comes to mind is that you have format or conditional
format options that are selecting the same color for foreground and
background.
 
Top