NESTED iF STATEMENT

[ruplekar]

HI, help on below if statement> i am getting " you have entered too many arguments" message.

=IF(AND($J$12>=A20,$A20>$I$12,$J$12>A19),(LOOKUP(I20,'CLICK CHARGES'!$N$3:$O$10,'CLICK CHARGES'!$Q$3:$Q$10*I20)),IF(AND($M$12>=A20,$L$12>$J$12),LOOKUP(I20,'CLICK CHARGES'!$N$14:$O$21,'CLICK CHARGES'!$Q$14:$Q$21*I20)),IF(AND(O12>L12,O12>M12),LOOKUP(I20,'CLICK CHARGES'!N25:O32,'CLICK CHARGES'!Q25:Q32*I20),0))

 

[sriche01]

HI, help on below if statement> i am getting " you have entered too many arguments" message.

=IF(AND($J$12>=A20,$A20>$I$12,$J$12>A19),(LOOKUP(I20,'CLICK CHARGES'!$N$3:$O$10,'CLICK CHARGES'!$Q$3:$Q$10*I20)),IF(AND($M$12>=A20,$L$12>$J$12),LOOKUP(I20,'CLICK CHARGES'!$N$14:$O$21,'CLICK CHARGES'!$Q$14:$Q$21*I20)),IF(AND(O12>L12,O12>M12),LOOKUP(I20,'CLICK CHARGES'!N25:O32,'CLICK CHARGES'!Q25:Q32*I20),0))

Try the following:
=IF(AND($J$12>=A20,$A20>$I$12,$J$12>A19),(LOOKUP(I20,'CLICK CHARGES'!$N$3:$O$10,'CLICK CHARGES'!$Q$3:$Q$10*I20)),IF(AND($M$12>=A20,$L$12>$J$12),LOOKUP(I20,'CLICK CHARGES'!$N$14:$O$21,'CLICK CHARGES'!$Q$14:$Q$21*I20),IF(AND(O12>L12,O12>M12),LOOKUP(I20,'CLICK CHARGES'!N25:O32,'CLICK CHARGES'!Q25:Q32*I20),0)))

The last if statement did not get in. I moved a parentheses to the outside.

 

[ruplekar]

HI sriche01,

iT WORKED...Thanks a lot for the help.

 

[sriche01]

You're welcome!