I've got a new question. What is the formula for changing information in one
field on a worksheet and update that same informationin the appropriate field
on another worksheet?

"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