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