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.

I can't deduce the logic you are applying here. Can you post some more
examples of what you want to input and how you would like the output to
appear?

Pete

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

Thanks anyway.

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




"Pete" wrote:

I can't deduce the logic you are applying here. Can you post some more
examples of what you want to input and how you would like the output to
appear?

Pete

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

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

You can "pull" the information from one cell to another with a formula like:

=if('sheet1'!="","",'sheet1'!a1)

If you have a table of values and want to return a value from a cell on the same
row, you could use =vlookup() or =index(match()).

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

clayblay wrote:

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


--

Dave Peterson