This requires a series of nested IF functions. It would start with this
(assuming "retail" is in cell C2):

=IF(C2<£5.00),£2.99,IF(C2£4.99<£10.00),£3.99,etc, etc. Be sure to put
enough )))) marks at the end of the formula. The Excel help function is very
useful on this; press the F1 key and in the Answer Wizard type "Functions."
Then select "IF worksheet function" for more information. Also note that if
postage for the first increment is less than £5.00, the next argument must
start with a retail price of £4.99, not £5.00. Otherwise the formula won't
know how to treat a retail price of exactly £5.00.

"stewartlogan"
wrote in message
news:stewartlogan.22yzre_1139502041.4543@excelforu m-nospam.com...

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