Thread: Division help?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
clayblay
 
Posts: n/a
Default Division help?

Thanks very much. This is excellent. I guess I have to start thinking
"outside the box." Please excuse the cliche.

"Dave Peterson" wrote:

If you put 16 in A1,
you can put this in B1: =int(a1/3)
you can put this in C1: =b1
you can put this in D1: =a1-b1-c1




clayblay wrote:

In MS Excel I would like to show a quotient in three separate columns such as
16/3 = 5 + 5 + 6. Can this be done? Please let me know a.s.a.p.


--

Dave Peterson