Evaluating a formula for multiple inputs and getting multiple outputs

[BREOL]

Hello all,
Brand new rookie to Excel, never used it to do anything other than chart data before. I have a list of data entries that I need to have divided by a large number and get the individual outputs. How do I do this? Please be gentle.

[shukla.ankur281190]

Assuming you data is in A column then try

B1

Please Login or Register  to view this content.

and drag down

[FDibbins]

Hi, welcome to the forum

Your question is a little vague

Do you mean you have a bunch of cells in a column, and you want to divide each 1 by a constant value - and have that answer appear in another cell?
or...................?

[BREOL]

I don't think I explained myself very well. I have a list of data points from A2-A37. I want to divide each and every one of those points by a separate, unrelated integer value and return an answer for every data point in a different list, ie. C2-C37. I don't know how to do that.

[FDibbins]

Maybe this?

C2=A2/your-number
copied down

Instead of hard-coding your-number, you could put in it's own cell and then reference it - that will make it easy to change your-number, if you need to...
=A2/$D$2
where D2 contains your-number. Note the use of $ there, that "locks" the cell so it wont adjust as you copy it down

[BREOL]

That did the trick, thanks a plenty for the help!

[FDibbins]

Happy to help and thanks for the feedback