Forum Discussion

Copper Contributor

Sep 11, 2023

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...

Formulas and Functions

office 365

Riny_van_Eekelen

Platinum Contributor

Sep 11, 2023

SoyAllenChiu

Can't really test your formula and there may be better/other ways, but perhaps this is what you want.

=IF(OR(ISNUMBER(SEARCH("INTEREST PAYMENT",B157)),ISNUMBER(SEARCH("REWARD",B157))),M157+O157+Q157,0)

or in format that is easier to read:

=IF(
    OR(
        ISNUMBER(SEARCH("INTEREST PAYMENT", B157)),
        ISNUMBER(SEARCH("REWARD", B157))
    ),
    M157 + O157 + Q157,
    0
)