Help
I am trying to reduce a total in divisions of 500 to give me a total for each 500 reached and leave a remainder
ie
231
456
322
124
220
= 1353
/500 = 2
remain =353
any help please?
Help
I am trying to reduce a total in divisions of 500 to give me a total for each 500 reached and leave a remainder
ie
231
456
322
124
220
= 1353
/500 = 2
remain =353
any help please?
If you enter the formula "=MOD(1353,500)" into a cell, the result will be
353.
"Paul Rush" <[email protected]> wrote
in message news:[email protected]...
>
> Help
> I am trying to reduce a total in divisions of 500 to give me a total
> for each 500 reached and leave a remainder
>
> ie
>
> 231
> 456
> 322
> 124
> 220
>
> = 1353
> /500 = 2
>
> remain =353
>
> any help please?
>
>
> --
> Paul Rush
> ------------------------------------------------------------------------
> Paul Rush's Profile:
> http://www.excelforum.com/member.php...o&userid=37500
> View this thread: http://www.excelforum.com/showthread...hreadid=571541
>
Hi Paul,
assuming the figures are on a1:a6 and the sum on A7
on C7 use
=int(a7/500)
for the remain use
=((a7/500-int(a7/500))*a7)/(a7/500)
hth
regards from Brazil
Marcelo
"Paul Rush" escreveu:
>
> Help
> I am trying to reduce a total in divisions of 500 to give me a total
> for each 500 reached and leave a remainder
>
> ie
>
> 231
> 456
> 322
> 124
> 220
>
> = 1353
> /500 = 2
>
> remain =353
>
> any help please?
>
>
> --
> Paul Rush
> ------------------------------------------------------------------------
> Paul Rush's Profile: http://www.excelforum.com/member.php...o&userid=37500
> View this thread: http://www.excelforum.com/showthread...hreadid=571541
>
>
Thanks for the replys
Marcelo, the formulas worked fantastically well. The stress is over!
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks