I need to create a formula that includes all the following rules in one: 1. Up to 5 years equals 8

2. More than 5 years up to 15 years, equals 12

3. More than 15 years equals 24Hire Date Service Years

02/21/77 35 years 0 months 1 days

07/15/96 15 years 7 months 7 days

07/02/01 10 years 7 months 20 days

03/03/03 8 years 11 months 19 days

Any help will be appreciated.Meli

Read up on the IF function in the Excel Help files (or via Google). Specifically you are going to need a Nested IF, where the

value_if_falsearguments are going to be more IF functions.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History