Thread: Divide Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Divide Function

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!

"JMW" wrote:

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?