| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Too few arguments | Excel Worksheet Functions | |||
| IF-more than 7 arguments | Excel Discussion (Misc queries) | |||
| And, if, arguments.... | Excel Worksheet Functions | |||
| arguments | Excel Discussion (Misc queries) | |||
| Are there too many arguments | Excel Worksheet Functions | |||
Linear Mode
