Forum Discussion
PLEASE HELP -__-
I am trying to make a formula that will allow the result to be based on what input. Example, the formula will check if one of these terms is filled in "INTEREST PAYMENT" OR "REWARD". BAsed on those t...
=IF(ISNUMBER(SEARCH("INTEREST PAYMENT",B157)),
SUM(K157+O157+Q157),
IF(ISNUMBER(SEARCH("REWARD",B157)),
SUM(M157+O157+Q157),0))
This works in my Excel for the web sheet.