When the cash salary is to be disbursed to many employees, the currency of different denominations are required to make the payment. Some times currency notes of few denominations may not be available. Before making the payment the payer should be ready with the cash of required denominations.
The excel sheet is prepared to calculate the currency notes of different denominations required for paying the amount. The logic is developed considering that there is a shortage of currency notes of Rs. 10.
The amounts payable to each employee should be updated in Column "C" and the amount should be rounded off to nearest rupee. When the amount is updated it will show the number of currencies with different denominations required to pay the amount. If any currency with particular denomination is not available the currency value in the top can be deleted and the worksheet will not consider that particular denomination for calculation. The total is also verified with the amount and if there any difference column will show the difference if any.
 |
| click to enlarge |
The excel file can
be downloaded and can be modified as per the requirement.
Thanx Bro Nice Coding
ReplyDeleteI like your article,
ReplyDeletebisnis sampingan health, cure and business health women cure beauty health, cure and beauty bisnis online gratis bisnis rumahan ibu judul skripsi pai jilbab murah game online bisnis online cyst how to newest how to newest The above article is nice and interesting, thank you willing to share!.. Very GOOD..Interesting article
It's really helpful for me
ReplyDeleteno file found..
ReplyDeleteDOWNLOAD LINK IS PROVIDED IN THIS SENTENCE:
DeleteThe excel file can be downloaded and can be modified as per the requirement.
no download link
ReplyDelete