Forum Discussion
SoyAllenChiu
Oct 01, 2023Copper Contributor
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...
HansVogelaar
Oct 01, 2023MVP
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))
SoyAllenChiu
Oct 02, 2023Copper Contributor
Thank you.