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