LinkBack URL
About LinkBacks
Hi,
I had to create this folio to break down a certain amount of money in bank notes and coins.
I am publishing the sheet here in case it can be of any help to someone (I could not find anything online).
Regards,
Alberto
Hi,
I had to create this folio to break down a certain amount of money in bank notes and coins.
I am publishing the sheet here in case it can be of any help to someone (I could not find anything online).
Regards,
Alberto
Last edited by 6StringJazzer; 03-10-2020 at 11:45 AM. Reason: Moved from Excel Formulas & Functions
Psssssst.... You missed out the 0.10 & 0.01 - or roundup/down the pennies
Last edited by BlindAlley; 03-10-2020 at 12:24 PM.
Uploading an attachment will assist Forum Members in finding the correct Solution for you. Create a dummy worksheet if necessary, add your start data and show where / what your expected results should be. TO ADD A FILE:
Go to 'Advanced. click on 'Manage Attachments. Select 'Browse & Choose your file, Select 'Upload and then close the Attachment window.
Hi,
no no, I did not forget, I just did not need them.
However, why should I use roundup pennies?
Thanks,
Alberto
Well if you put $895,48 in as a start value and check the totals returned you get $895.25 back. Putting in the 0.10 you get $895.45 back not .48. I mentioned the round up/down pennies for the countries like Canada that have eliminated pennies.Originally Posted by Giulio Severini
Oh, yes, but for my purposes it is ok like that. Anyone will fine tune the sheet as they need
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks