View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Multiplying one known number with fluctuating numbers in cells

Hi let's say the numbers you want to multiply by 0.384 are in column A. Put
0.384 in a Cell (I used C1) and this in B1 and drag down

=A1*$C$1

Mike

"Georgia" wrote:

This should be really easy, but I am very elementary with formulas. I can
add and subtract two numbers basically.

Okay, I made a spreadsheet to figure taxes. I need to figure the sales tax
on my gasoline receipts. So I need to multiply .384 by different numbers
(from each receipt) ..... and yes, I'm running late with taxes! :-)

Any help would be appreciated.

Thanks so much.