Excel question
My staff are paid based on a wage scale. Lets say :
Sales Pay
$1 - $10 $5
$11 - $20 $12
$21 - $30 $15
$31 - $40 $22
What I want to do is enter the $ amount of sales in one cell and have the adjacent cell give me the rate of pay. Thanks very much in advance!
KG
|