Nested IF Function
It's returning FALSE because you've constructed it IF THEN IF THEN IF ELSE
Should be structured IF THEN ELSE IF THEN ELSE IF
Try something like =IF(AND(F28=100,E130),[then what??],IF(F130,I13,"")))
You need to figure out what goes in the [then what??] part.
Dave
--
Brevity is the soul of wit.
"ConfusedNHouston" wrote:
I've done nested if's before but I'm running into some strangness:
Here's what I'm entering in the formula line:
=IF($F$28=100,IF(E130,IF(F130,I13,"")))
It's working, but rather than entering "0" for the false condition it's
writing FALSE in the cell - it just looks ugly. How do I stop it from doing
that?
|