Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
only seven arguements allowed
0 views
Skip to first unread message
soceallaigh
Jan 18, 2004, 12:21:35 PM1/18/04
to
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.
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"))))))))))))))
Peo Sjoblom
Jan 18, 2004, 12:39:52 PM1/18/04
to
You already received an answer to the same question posted some hours ago
--
Regards,
Peo Sjoblom
"soceallaigh" <socea...@hotmail.com> wrote in message
news:05dc01c3dde7$86407160$a501...@phx.gbl...
0 new messages