only seven arguements allowed

S

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"))))))))))))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Only seven arguements allowed ? 2
Portmon log for Paul (Part1) 22
If time Go to Function 1
Graph won't interpolate? 4
3 value chart l w h comparison 20$ paypal gift card 13
need help for 3 value table 20$ paypal gift card 5
Are CRT monitor registers standard? 3
Oracle Client Error OCI-22053 Overflow Error 8

Top