MOD function

G

Guest

I really need to find out how to divide many numbers by the same divisor. I
tried with the MOD function, but received an error. I have about 1800
numbers to divide by one divisor and then need to see the result of each
division in a set of columns

Thanks
Maurine
 
R

R.VENKATARAMAN

I hope I understood your problem. why not put the divisor in a cell and use
that cell as absolute reference.
 

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

How do I use the MOD formula to do the same action to a column? 1
Limit to MOD function 2
Excel Repeating a RAND() function under certain conditions 0
Overcome LOOKUP limits and NOW() 5
Divide by zero error 3
MOD Function: MOD(7.0,1) = 1 Why? and how to work around it. 13
Mod(number;divisor) 1
fill in columns 1

Top