IF-more than 7 arguments in
 

The following formula is working perfectly but I NOW need to add ONE more
test....

I need to check T14...if T14 is equal to the word "Forever" the result
should be "0" and there should not be any more testing ....if not "Forever"
then continue testing

=IF(G14=Z$3,(V14*AA$3),IF(G14=Z$4,(V14*AA$4),IF(G1 4=Z$5,(V14*AA$5),IF(G14=Z$6,(V14*AA$6),IF(G14=Z$7, (V14*AA$7),IF(G14=Z$8,(V14*AA$8),IF(G14=Z$9,(V14*A A$9))))))))

How can I simplify this equation to include the additional test?

Thanks.

IF-more than 7 arguments in
 

=if(t14="Forever",0,v14*vlookup(g14,$z$3:$aa$9,2,0 ))

"Carolina" wrote:

The following formula is working perfectly but I NOW need to add ONE more
test....

I need to check T14...if T14 is equal to the word "Forever" the result
should be "0" and there should not be any more testing ....if not "Forever"
then continue testing

=IF(G14=Z$3,(V14*AA$3),IF(G14=Z$4,(V14*AA$4),IF(G1 4=Z$5,(V14*AA$5),IF(G14=Z$6,(V14*AA$6),IF(G14=Z$7, (V14*AA$7),IF(G14=Z$8,(V14*AA$8),IF(G14=Z$9,(V14*A A$9))))))))

How can I simplify this equation to include the additional test?

Thanks.

IF-more than 7 arguments in
 

WOW! WOW! WOW! Thanks a million. You are a life saver! It worked perfectly
Carolina

"bpeltzer" wrote:

=if(t14="Forever",0,v14*vlookup(g14,$z$3:$aa$9,2,0 ))

"Carolina" wrote:

The following formula is working perfectly but I NOW need to add ONE more
test....

I need to check T14...if T14 is equal to the word "Forever" the result
should be "0" and there should not be any more testing ....if not "Forever"
then continue testing

=IF(G14=Z$3,(V14*AA$3),IF(G14=Z$4,(V14*AA$4),IF(G1 4=Z$5,(V14*AA$5),IF(G14=Z$6,(V14*AA$6),IF(G14=Z$7, (V14*AA$7),IF(G14=Z$8,(V14*AA$8),IF(G14=Z$9,(V14*A A$9))))))))

How can I simplify this equation to include the additional test?

Thanks.