excel

J

jim

I need a templete that will add a number...say 49 multipied by 1.1 1.2 1.3
1.4....all the way to whole number 20. its for a pricing guide I'm tyring to
build. I have two prices to work with. $ 49.00 and 65.73. They need to be
able to simply follow the chart to the number and record. they do not have a
computer to do this on, so I'll print big charts for them.
i.e. 65.73 times 1.5 = 98.59
 
B

Bob I

You will need to create it yourself. In Excel 2003 simply insert 1.1 in
cell A1, 1.2 in Cell A2. Then with the mouse, select A1 and A2, then
drag the lower right corner of the selection down the column until you
get a value of "20". Now in B1, insert =49*A1 and then Copy and paste
that down column B next to "1.1" thru the "20" you created.
 
Top