Wages Denomination Analysis Tool


I need a spreadsheet which will calculate individual denominations needed for a specific wage, i.e.for  £842.78, how many £20, £10, £5, £2, £1, .50p, .20p, .10p, .05p, .02p, .01p are needed to make up the wage. Can anyone help? 



May I ask why you need this? It seems rather odd given how people are paid these days.
don (rep: 1785) Aug 2, '18 at 2:58 am
We have casual workers who are still paid in cash. Normally Sage Payroll would do this function but there are specific reasons why it can't on this occasion, so I need something to get me passed this 1 off event.
MarkPalmer (rep: 2) Aug 2, '18 at 4:34 am
Add to Discussion


Selected Answer

Generally speaking, worksheet design isn't what is discussed here on the forum unless the topic comes up in relation to data manipulation. You may find design templates by searching the web but most people make up their own.

Don: Sorry to clothe this advice in the cloak of an "Answer" but it seems you did something recently which disables the Discuss and Add to Discussion buttons.


Answer the Question

You must create an account to use the forum. Create an Account or Login