View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul Rush Paul Rush is offline
external usenet poster
 
Posts: 1
Default 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