Getting FALSE Result

[maxthebear]

I have the following formula:


=IF(AND(A5=A4,C5=C4),(IF(G5="T",(H5*I5*122%/2),IF(E5=0,"-",(H5*I5)*122%)*(F5))))


When the first IF is not true I get FALSE, instead of a number..

Any help is appreciated

[NBVC]

What number are you expecting? You have no FALSE argument in the main IF()

[JBeaucaire]

You've constructed three IF statements nested in such a way that ALL of them have TRUE formulas, and NONE of them have FALSE formulas. None of them.

As shown, if the opening AND() isn't true, you'll get nothing.

Break out the logic and the formulas one logic string at a time, explain what you want to happen. Then we'll help you put the formulas back together.

[maxthebear]

The last if statement is supposed to be calculated when the first if is not true. It is giving me a False instead of a number. What do I need to add...

Max

[NBVC]

Perhaps something like this then:

=IF(AND(A5=A4,C5=C4),IF(G5="T",(H5*I5*122%/2),""),IF(E5=0,"-",(H5*I5)*122%)*(F5))

where you can replace the "" with something if that IF() is FALSE...

[maxthebear]

I copied your formula in but I still got a false result. Did I miss something,,

[NBVC]

Which formula?