G
Guest
Hi
my daughter has to do a poyroll excercise for school. While I can help her
with most of it I am having trouble helping her do a VLOOKUP for the tax
table.
eg Income Tax
$0.00 0.00%
$200.00 5.00%
$500.00 10.00%
$1,000.00 15.00%
$2,000.00 25.00%
$3,000.00 35.00%
$4,000.00 45.00%
What I need to help her with is a formula that basically states if total pay
is equal to or between two figure e.g 1000 to 2000 then the the appliacble
tax % is applied.
I really hope someone can help me out on this. I think the god like status I
used to hold for her slipping!!!
my daughter has to do a poyroll excercise for school. While I can help her
with most of it I am having trouble helping her do a VLOOKUP for the tax
table.
eg Income Tax
$0.00 0.00%
$200.00 5.00%
$500.00 10.00%
$1,000.00 15.00%
$2,000.00 25.00%
$3,000.00 35.00%
$4,000.00 45.00%
What I need to help her with is a formula that basically states if total pay
is equal to or between two figure e.g 1000 to 2000 then the the appliacble
tax % is applied.
I really hope someone can help me out on this. I think the god like status I
used to hold for her slipping!!!