IF or IF(And) formula for 3 logical tests - Excel 2016

cdngirl

New Member
Joined
Feb 26, 2013
Messages
3
I know this is a fairly easy question but as my Excel is very rusty and I am trying to learn the features of Excel 2016 this has me stumped. The question I have been given is - Enter a function to calculate the award give - my chart has from 4 years of service to 27 years. If the employee has greater than or equal 20 years, they will receive a Suitcase. If the employee has greater than or equal to 15 years, they will receive Steak Knives. I have been able to figure the formula for the greater than 20 years but the formula needed to calculate 15 ruling out anyone with less than 15 is causing problems. I am not sure if I should use the IF function or IF(And) or if neither of these are correct. TIA

 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,397
Office Version
365
Platform
Windows
How about something like
=IF(C1>=20,"Suitcase",IF(C1>=15,"Steak knives",""))
 
Last edited:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,397
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Forum statistics

Threads
1,082,501
Messages
5,365,942
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top