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.