Pay based on age calculator

[Yeezy316]

[FONT=&quot]I’m trying to put a excel sheet together for a local business We are trying to find out a method to use an excel function to calculate pay based on age using age ranges , Ie if pay age range is 18 - 21 pay would be $5.00 or if age is 21 - 24 pay would be $10. Thank you[/FONT]

 

[AlphaFrog]

You could use something like this where A1 is the Age

=LOOKUP(A1,{0,18,21,24},{0,5,10,15})

 

[Bratamoli]

Assuming the age is in cell A2, I would use something like this:
=IF(A2>=65,$20,IF(A2>=50,$18,IF(A2>=35,$15,IF(A2>=25,$12,IF(A2>=21,$10,IF(A2>=18,$5,"too young"))))))

[Please note, the dollar signs are only there to make this easier to read and translate; they will have to be removed for the formula to work.]

 

[Bratamoli]

Scratch that. I would use this:

You could use something like this where A1 is the Age

=LOOKUP(A1,{0,18,21,24},{0,5,10,15})

 

[Yeezy316]

Okay thanks guys, it would still work even if I wanted to make various age ranges ie, 21-24 25 - 28?

 

[AlphaFrog]

Okay thanks guys, it would still work even if I wanted to make various age ranges ie, 21-24 25 - 28?

Yes. Add as many age ranges as you want.