Or maybe this one, if you prefer......

=LOOKUP(A2,{0,4.99,9.99,14.99,19.99,24.99,29.99},{ 2.99,3.99,4.99,5.99,7.99,9.99,12.99})

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

Put this formula in B2 and copy and paste it down column B as far as you have
data in column A.........a quick way to do that is to , after it's entered,
just left click on B2 and then double left-click on the little black square
in the lower right hand corner of B2......the formula will autocopy down
column B

=IF(A2=30,12.99,IF(A2=25,9.99,IF(A2=20,7.99,IF( A2=15,5.99,IF(A2=10,4.99,IF(A2=5,3.99,2.99))))) )

Note, this is a long formula, and should all be entered in B2 in one long
line......be careful of email word-wrap that may carry it over to two
lines.......carefully hand type it in B2 if necessary.

hth
Vaya con Dios,
Chuck, CABGx3



"stewartlogan" wrote:


thanks for your reply Chuck - really appreciate your effort. Problem is,
i havent got a clue what you mean

can someone please explain in simple terms for me - like i say, ive
never used excel before


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