How do I use the MOD formula to do the same action to a column?

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

Guest

I am trying to divide a whole column of numbers by the same divisor and I am
stuck. The solution is gone from my brain.
 
If you want to divide them in place, put your divisor in an empty cell, copy
it, select the cells to be divided, and use Edit>Paste Special>Divide.
 

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

MOD function 1
help needed in excel 07 0
Formula Constant 2
Overcome LOOKUP limits and NOW() 5
putting number against certain words formula 0
Use MOD? 4
use the number in one cell for different formulas 2
Excel Catagorise AM or PM 7

Back
Top