Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? -- 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? -- 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? -- 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
Function to list values of last 3 non-blank cells in a vertical bl | Excel Worksheet Functions | |||
How To Use Cells Without Values in a Formula | Excel Worksheet Functions |