Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Wages Denomination Analysis Tool

0

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? 

Answer
Discuss

Discussion

May I ask why you need this? It seems rather odd given how people are paid these days.
don (rep: 1989) 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

Answers

0
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.

Discuss


Answer the Question

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