Argument help - amounts in different rows divided by a constant

L

lawrencae

Column A has 50 rows of amounts: A10 through A60. I want to divide the
amounts in each of the rows by a constant number in E9, with the total
answers being placed in the row in E that corresponds to the same row number
in A. For instance, if A25 is 10,000 divided by the E10 constant 30.4, the
answer 328.95 should be in E25, which is the E row that corresponds to row
25 in the A column. What will be the structure of the arguments needed?

Please pardon me if I seem to be pedantic. I don't mean to be. I am trying
to be precise in my own way because I don't know how properly to convey this
information in a more professional manner.

Thank you for your help, whoever you are.
 
J

jwpitts

In cell E10 type =A10/E$9

Copy that formula down to cell E60. The $ sets the row number as absoulte,
and it will not change as it is copied down.
 

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

Top