Jul 10 2018
05:24 PM
- last edited on
Jul 31 2018
08:41 AM
by
TechCommunityAP
Jul 10 2018
05:24 PM
- last edited on
Jul 31 2018
08:41 AM
by
TechCommunityAP
Jul 11 2018 12:32 AM
Hi Gareth
I'm sure someone will probably have a better way to do this but this should work:
=IFERROR(IFS(AND(A1="Yes",B1="No"), "P3", AND(A1="Yes",B1="Yes"), "N/A", AND(A1="No",B1="No"), "P2"), "Not a valid combo")
I've used IFS for multiple conditions and have also added IFERROR to catch any invalid combos or entries.
Hope that helps. Sample file is attached.
Cheers
Damien
Jul 11 2018 08:25 AM
Hi Gareth,
Please use this formula:
=IF(AND(A1="Yes",B1="Yes"),"N/A",
IF(AND(A1="Yes",B1="No"),"P3",
IF(AND(A1="No",B1="No"),"P2","")))
Your formula works just fine, but IFS function isn't available in all versions of Excel!
It currently available only for Office 365 subscribers.
Regards
Jul 11 2018 04:20 PM - edited Jul 11 2018 08:38 PM
Hi Haytham
You make a good call out and Gareth has two different ways to do the same thing for his learning benefit.
Great team effort!
Cheers
Damien