Divide Function

  • Thread starter Thread starter JMW
  • Start date Start date
J

JMW

I have a row of numbers that all need to be divided by 3. I need the answers
to show up in the column next to them. Does anyone know how I do this?
 
so, you have a number in A1, need the result in B1, value in C1, need result
in D1, etc.?

If it's like that, type =A1/3 in B1, then copy B1, highlight row 1, Edit -
Go to - Special - Blanks, paste.

All done!
 
Numbers in column A

In B1 enter =A1/3

Double-click on the fill handle of B1 to copy down.


Gord Dibben MS Excel MVP
 
Back
Top