Division help?

[clayblay]

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.

 

[Pete]

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

 

[Dave Peterson]

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]

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

 

[clayblay]

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

 

[clayblay]

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

 

[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()))