Forum Discussion
HELP WITH FORMULA
Hi, I want to create a formula where I prevent some multiple inputs in 1 single cell. =(IF(ISNUMBER(SEARCH({"ACCOUNT LATE","ACCOUNT PENALTY","SAVING PENALTY","BUSINESS LATE","BUSINESS PENALTY","E...
Use
=(IF(OR(ISNUMBER(SEARCH({"ACCOUNT LATE","ACCOUNT PENALTY","SAVING PENALTY","BUSINESS LATE","BUSINESS PENALTY","ENTERPRISE LATE","ENTERPRISE PENALTY","OTHER LATE"},B85))),"INPUT ERROR",0))
Thank you.