IF and IF and IF
Hi there,
I need a formula which should be quite straight forward (in my head) but if I do it the way I think it should work it comes back with an error. I hope you can help me
I have the following fields:
Name
Start Date
Eligible (this should be a formula)
Today's Date
Criteria:
Employees that have been with the company for less than 1 year - return 0
Employees that have been with the company between 1 and 2 years - return 3
Employees that have been with the company for 2+ years - return 5
Is that do-able?
Many thanks,
Ramona
|