Excel - Needing Help Creating Formula

February 22, 2012 at 10:27:08
Specs: Windows XP
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 24

Hire 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


See More: Excel - Needing Help Creating Formula

Report •


#1
February 22, 2012 at 11:13:20
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_false arguments are going to be more IF functions.

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


Report •
Related Solutions


Ask Question