problems making this IF formula work

Hi guys,

I'm working on this IF statement and having some troubles with excel accepting it. I was wondering if anyone could help me out with it


=IF((E3>(P22+(P22*0.025)),IF((K4<K7,L4>L7)),IF((L2<L3,TRUE))

Any help with this would be huge!

Below shows where you need to put your value if true and value if false.

Hope this helps.

=IF(E3>(P22+(P22*0.025)),IF(AND(K4<K7,L4>L7),IF(L2<L3,"All True","Last IF False"),"Middle IF False"),"First If False")

[QUOTE=FDibbins;3171902]the syntax for an if() statement is...

=if(criteria-to-test,what-to-do-if-test=TRUE,what-to-do-if-test=FALSE)

you have 3 nested if() statements, they each have the criteria-to-test, and they each have what to do if TRUE, but none of them have what to do if FALSE



Excel will accept this, but i have NO idea if it will give you what you want...


Sorry for the delay, been busy tonight but i do appreicate the reply

I tried your formula and its really not working out

What i'm trying to do is this

first argument, see if that condition applies

If so

Does the sequence follow to be true

Originally Posted by Fieldstone

Below shows where you need to put your value if true and value if false.

Hope this helps.

=IF(E3>(P22+(P22*0.025)),IF(AND(K4<K7,L4>L7),IF(L2<L3,"All True","Last IF False"),"Middle IF False"),"First If False")

Fieldstone,

thanks for this,

i tried it out but it doesnt work.

what do you input in for the ALL True or Last if fasle or middle if false or first if false...?


I'm not to sure how to interpret this formula