I’ve gone through countless tutorials as well as the forum and I just don’t understand why this is not working.
I have a single-select for “round/type of item” with options like charge-off1, charge-off2, etc.
I need for the formula to be if round/type of item is charge-off1 = delete it, if round/type of item is charge-off2 = prove it, if blank = blank
This is what I’ve gotten from one of the forum posts I just saw:
IF(Round/type of item = charge-off1, “delete it”, IF(Round/type of item = charge-off2, “prove it”, IF(Round/type of item=BLANK(),BLANK())))
No matter what I do, it gives me an error! Please help! Does this just not work with single or multiple select??
I need it to be single-select = text, formula = text
