On Fri, 21 Apr 2006 05:30:01 -0700, AJ
wrote:

I have a business,that needs me to seperate cash according to denominations.I
use excel for wage slips,eg. if i pay R330-00 to an employee,below all the
slips it must show that i need 1xR200-00 note; 1xR100-00 note; 1xR20-00 note
& 1xR10-00 note.I had this formula before,but an employee deleted it.

Please can you help me.


See this similar thread back in March

http://groups.google.com/group/micro...ad173573a1dbfb


Note the last point that the final (smallest denomination) coin needs
a slightly altered formula to take account of rounding

HTH.
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________