how do i add multiple cell in the same row then multiply the value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
here is what i am trying to do. i would like to add the following:

in A21 i need to do these calculations below.

Add A1 to A20.
after that i need to multiple the total by by 0.07 in the same cell that
being in A21
Can someone help me with the formula please?
 
You might want to take this question to an Excel news group. You might find a
reply like
=Sum(A1..A20) * 0.07
 
Global said:
hi,
here is what i am trying to do. i would like to add the following:

in A21 i need to do these calculations below.

Add A1 to A20.
after that i need to multiple the total by by 0.07 in the same cell that
being in A21
Can someone help me with the formula please?
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

prob in IF then else statement 1
Copy formulas in Column 1
Excel How to add numbers in same cell? 2
Want code to copy to ABOVE row 22 column A on sheet 1 10
Excel 2003 formula 2
Using validation to move cells 3
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
How can I remove the previous lock cells and keep the new ones. 2

Back
Top