Only seven arguements allowed ?

[SOCEALLAIGH]

i am a novice user of excell 2000 but have a specific
requirement i need to create a formulae to produce a
postage cost defined by 16 different weight catagories i
have included my attempt but receive an error message and
help tells me i can only include seven arguements,when i
only use the first seven it works fine,is there anyway
around this. Any assistance would be greatly appreciated.


(IF(D2<=60,"28",IF(D2<=100,"42",IF(D2<=150,"60",IF
(D2<=200,"75",IF(D2<=250,"88",IF(D2<=300,"101",IF
(D2<350,"115",IF(D2<=400,"137"),IF(D2<=450,"156",
(D2<=500,"174",IF(D2<=600,"210",IF(D2<=700,"264",IF
(D2<=750,"264",IF(D2<=800,"306",IF(D2<=900,"336",IF
(D2<=1000,"367",IF(D2>1000,"N/A"))))))))))))))

 

[Frank Kabel]

Hi
Excel allows only 7 nested IF statement and as you can see above this
the formula gets quite complicated. For your problem i would suggest
the following:
1. On a separate sheet (say sheet 2) create a lookup table: In column A
store your weight categories and in column B the postage cost
2. Replace your formula with the following
=IF(D2="","",VLOOKUP(D2,'sheet 2'!$A$1:$A$16,2,False))

HTH
Frank

 

[Guest]

Many thanks will try that i appreciate your response and apologise for posting the query twice
Again many thank
stephe
----- Frank Kabel wrote: ----

H
Excel allows only 7 nested IF statement and as you can see above thi
the formula gets quite complicated. For your problem i would sugges
the following
1. On a separate sheet (say sheet 2) create a lookup table: In column
store your weight categories and in column B the postage cos
2. Replace your formula with the followin
=IF(D2="","",VLOOKUP(D2,'sheet 2'!$A$1:$A$16,2,False)

HT
Fran

SOCEALLAIGH wrote