Posted to microsoft.public.excel.worksheet.functions

ekkeindoha ekkeindoha is offline

external usenet poster

Posts: 46

best breakdown

Can anyone please help wih a formula to show kid's the beakdown of a
currency amount.
eg: R35.00 = 1 x R20, 1 x R10 and 1 x R5
R50.00 = 2 x R20 and 1 x R 10
R 9.00 = 1 x R5 and 2 x R2
the currency found are 1,2,5,10,20 and 50

thnks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
breakdown months	Hank	Excel Discussion (Misc queries)	3	September 3rd 09 03:58 AM
Monthly Breakdown	roy.okinawa	Excel Worksheet Functions	2	March 15th 09 10:46 PM
Excel nervous breakdown	[email protected]	Excel Discussion (Misc queries)	0	December 5th 06 02:27 PM
Breakdown	AJ	Excel Worksheet Functions	1	May 3rd 06 09:02 PM
How 2 breakdown $$$ into $ $ $?	mjpage	Excel Discussion (Misc queries)	2	January 8th 06 12:16 AM

All times are GMT +1. The time now is 06:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us