IF function with multiple inequalities

Hey guys first time posting...

Trying to find a way to write an if function with multiple inequalities i.e.

if cell 0<a1<5 display 60, 5<a1<8 display 120, 8<a1<20 display 140

not sure what the best way to go about this is but essentially Im dealing with employee vacation accruals and employees who have been at the company in different ranges accrue different numbers of vacation days throughout the year.

Thank You!

You can string a number of IF functions together to achieve that, like this:

=IF(A1<5,60,IF(A1<8,120,IF(A1<20,140,"other_value")))

but if you have a lot of categories it would be better to set up a little table and use VLOOKUP.

Hope this helps.

Pete

Thanks Pete

=IF(P623<365,(P623/365)*120,IF(P623<1095.25,120,IF(P623<1826,160,IF(P623>1826,200,"FALSE"))))

ended up using this worked fine

Okay, glad you got your answer. Strictly speaking, you don't need to put quotes around FALSE.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete