Hi, I am working on a spreadsheet to do with payroll and would like to know
how I set up the look up function to cater for the following:

If pay is between
$0 and $95 then deduct $0 plus $0
$96 and $345 then $0 plus 20 cents for every dollar over $96
$346 and $480 then $63 plus 25 cents for every dollar over $346
$481 and $672 then $96 plus 40 cents for every dollar over $481
$673 and $961 then $183 plus 47 cents for every dollar over $673
$962 and over then $308 plus 48 cents for every dollar over $96

I tried to do a lookup function along the following lines, but got myself in
a mess, plus I don't know how to calculate the latter "plus" part.

<=95 $0
95<=345 $0 + 20 cents for every dollar over $96
345<=480 $63 + 25 cents for every dollar over $346
480<=672 $96 + 40 cents for every dollar over $481
672<=961 $183 + 47 cents for every dollar over $673
962 $308 + 20 cents for every dollar over $962

Sorry to ask what is probably quite obvious to most!

I look forward to a response. Many thanks. :-)

--
Trish