How to calculate vacation pay

[hyewiz]

Hi there
I need a formula to show me how much vacation pay there is on every weekly pay based on a 4% for example

A1 = has a $300.00 paycheck
C1 = should show $300.00 X 4% = $12.00 need to be exact decimals.
and in
D1 = $12.00
D2 = D1+D2
D3 = D2+D3 and so on

thank you

 

[Giordano Bruno]

This is baffling. The first part of the question is too simple, and what are all these "and so ons" If D2 = D1+D2 you have a circular reference.

 

[CharlesChuckieCharles]

You appear to have answered it yourself

Whats the problem?

 

[hyewiz]

Thank you for your fast reply,
after long forum reading I have managed to get almost what I was looking for, bellow is the code, now
how can I make the C1 shows $11.54 instead $12.00 4% of the $300.00 is 12 and same with the rest

Excel Workbook
	A	B	C	D
1	$300.00	4%	$11.54	$11.54
2	$600.00		$23.08	$34.62
3	$300.00		$11.54	$46.15
4	$500.00		$19.23	$65.38
5
6
Sheet1

Thank you

 

[CharlesChuckieCharles]

Thank you for your fast reply,
after long forum reading I have managed to get almost what I was looking for, bellow is the code, now
how can I make the C1 shows $11.54 instead $12.00 4% of the $300.00 is 12 and same with the rest

Excel Workbook
	A	B	C	D
1	$300.00	4%	$11.54	$11.54
2	$600.00		$23.08	$34.62
3	$300.00		$11.54	$46.15
4	$500.00		$19.23	$65.38
5
6
Sheet1

Thank you

<TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=256><COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; HEIGHT: 13.5pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl65 height=18 width=64>300

</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=64>4%</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=64>12</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=64>12</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; HEIGHT: 13.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 height=18 width=64>600</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=64> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=64>24</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl69 width=64>36</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; HEIGHT: 13.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 height=18 width=64>300</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=64> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=64>12</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl69 width=64>48</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl63 height=17 width=64>500</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 width=64> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=64>20</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl69 width=64>68</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 48pt; HEIGHT: 13.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl68 height=18 width=64> </TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=64> </TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=64> </TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 48pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl70 width=64>

</TD></TR></TABLE>

Rate is B1 (4%)

<TABLE style="WIDTH: 384pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=512><COLGROUP><COL style="WIDTH: 96pt" span=4 width=128><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: #3867a6 1pt solid; BACKGROUND-COLOR: white; WIDTH: 96pt; HEIGHT: 13.5pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl67 height=18 width=128>300

</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=128>0.04</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=128>=A1*Rate</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=128>=C1</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 96pt; HEIGHT: 13.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl65 height=18 width=128>600</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=128> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=128>=A2*Rate</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=128>=D1+C2</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 96pt; HEIGHT: 13.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl65 height=18 width=128>300</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=128> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=128>=A3*Rate</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=128>=D2+C3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 96pt; HEIGHT: 12.75pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl65 height=17 width=128>500</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 width=128> </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: #3867a6 1pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=128>=A4*Rate</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl71 width=128>=D3+C4</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 96pt; HEIGHT: 13.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl70 height=18 width=128> </TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=128> </TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl70 width=128> </TD><TD style="BORDER-BOTTOM: #3867a6 1pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 96pt; BORDER-TOP: black; BORDER-RIGHT: #3867a6 1pt solid" class=xl72 width=128>

</TD></TR></TABLE>


this is all it needs

 

[hyewiz]

Thanks a lot this is what i have done with your help

Excel Workbook
	A	B	C	D
2	$300.00	4%	$12.00	$12.00
3	$600.00		$24.00	$36.00
4	$300.00		$12.00	$48.00
5	$500.00		$20.00	$68.00
6	$1,086.54		$43.46	$111.46
7
8
Sheet1