View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
stewartlogan
 
Posts: n/a
Default Can some one help me with a formula please?


Hey folks - sorry to barge in.

I am a new user of excel and am trying to create a 6500 product
spreadsheet for a website i am building.

What i want to do is as follows:
I have a column with my retail price. I want to create a column with my
postage price. I want the postage price to be proportionate to the
retail price.

Example, if retail is less than £5 postage is £2.99. If retail price is
more than £5 but less than £10, postage price is £3.99, if retail price
is more than £10 but less than £15, postage price is £5.99 and so on
and so forth.

Question is, how to i put this in a formula. Tried lots of ways but
keep messing it up.

I would really really appreciate someone helping me out!!

Thanks in advance
Stewart


--
stewartlogan
------------------------------------------------------------------------
stewartlogan's Profile: http://www.excelforum.com/member.php...o&userid=31371
View this thread: http://www.excelforum.com/showthread...hreadid=510637