excel spreadsheet cash denominations

satpam | 11:53 Thu 30th Apr 2009 | Business

2 Answers

I need an excel template to split cash wages amount in to coins and notes required - where to start?

Educational Consultancy-does it have to be limited company?

name for a butty van

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by satpam. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

factor-fiction

There is probably something already written but a starting point could be to use the 'Round down' facility. That will give you the pounds figure. Subtract that from the full price and you'll get the pence. Then you can manipulate those further to get different denominations- but it's a long process

satpam

Question Author

thanks factor30, I'll give it a go - if I get it right it will save time in the long run. I tried to find a template by googling - no joy

1 to 2 of 2

Do you know the answer?