Hi,

Whats' going on? It's a nested if statement that says

=IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250,$C$255,$C$249)))

IF ID606 = Y then return the contents of C254
If that evaluates as TRUE then that's the end of the matter but if ID606
isn't Y it carries on

IF ID606 = N then return C248
Once again if that's true then the formula stops but if ID606 is neuther Y
or N then it carries on and asks

If C256 is greater than C250 return C255 and if that's not true return the
contents of C249.

Mike



"Oldjay" wrote:

I have the following formula in a cell

=IF(ID606="Y",C254,IF(ID606="N",C248,IF($C$256$C$ 250,
$C$255,$C$249)))

Cell ID606 is blank

When I look at the function arguments it says both ID606='Y' and ID606="N"
are true.
What going on?

oldjay