Re: how to display answer as whole number and remainder
- From: "Tim Williams" <timjwilliams at gmail dot com>
- Date: Mon, 22 Oct 2007 19:41:39 -0700
You can use MOD() to find the remainder.
Tim
"ynot" <ynot@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DD331B7C-DB13-487D-A5B7-FB51FB1EC500@xxxxxxxxxxxxxxxx
I wanted to be able to divide one number by another and display the answer
as
a whole number (not rounded up or down) and then the remainder in separate
cells so I can apply other formulas to the answers later. EG 6000 / 305 =
19 r 205
.
- Prev by Date: Re: How to trim cell information
- Next by Date: Re: How to trim cell information
- Previous by thread: Using a userform to enter data to specific cells...
- Next by thread: RE: how to lookup a value in a table
- Index(es):
