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