deducting same amount from cells containing various values
 

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?:confused:


--
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

deducting same amount from cells containing various values
 

If you enter the formula "=MOD(1353,500)" into a cell, the result will be
353.
"Paul Rush" wrote
in message ...

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?:confused:


--
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

deducting same amount from cells containing various values
 

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?:confused:


--
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

deducting same amount from cells containing various values
 

Thanks for the replys

Marcelo, the formulas worked fantastically well. The stress is over!

thanks:)


--
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