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?