Trying to make an if statement that will return 4 outcomes based on the contents of the cell
If the cell is "Yes", "No", "NA", "Unknown", to return 0, 1, 2, 3 respectively.
I can use If(A1="Yes", 0,1) but not sure how to handle the other conditions
SWITCH would be a better call:
=SWITCH(A1,"Yes",0,"No",1,"N/A",2,"Unknown",3,"I'-'I")
Please try:
=IF(A1="Yes",0,IF(A1="No",1,IF(A1="Unknown",3,2)))
Anything other than the given selection in A1 (and not an error) and the formula would return 2.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With