Thread
:
varible calculation
View Single Post
#
7
Posted to microsoft.public.excel.newusers
kinsey
external usenet poster
Posts: 23
varible calculation
many thanks
--
kinsey
"Sandy Mann" wrote:
assuming that you mean:
1-299
300-399
400-
then try:
=LOOKUP(A1,{0,300,400},{30,35,40})
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"kinsey" wrote in message
...
I am trying to create a calculation for haulage/trucking charges
1-300 kilos £ 30
300-400 kilos £ 35
400-500 kilos £ 40
What formula could I use to accomplish this??
--
kinsey
Reply With Quote
kinsey
View Public Profile
Find all posts by kinsey