In A1 type .3 and format as currency

In A2 type 1 and in A3 type 2. Now highlight A2:A3 and drag fill down
as far as you want to go (300?).

In B2 type: =A2*$A$1

Now drag copy B2 down the same number of cells as you went in column A

You will now be able to get the prices for the weights and if the base
price changes you just have to change the value in A1


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=472794