Forum Discussion

SoyAllenChiu's avatar
SoyAllenChiu
Copper Contributor
Sep 11, 2023

SoyAllenChiu Riny_van_Eekelen OliverScheurich 

 

Hi thank u so much for the replies. I did all those steps before, but none of them results good. If you can see on the next photo below, in column "credit amount" there should be a formula that will allow the 2 formulas I made to be used based on what is filled in column "Description".

 

Formula 1 works like this:

=(IF(ISNUMBER(SEARCH("INTEREST PAYMENT",B157)),(SUM(K157+O157+Q157)),(0)))

That means: If in Description (B157) IS FILLED INTEREST PAYMENT, it will sum K157, O157, Q157.

 

Formula 2 works the same as 1 but changes based on the argument/term:

=(IF(ISNUMBER(SEARCH("REWARD",B157)),(SUM(M157+O157+Q157)),(0)))

That means: If in Description (B157) IS FILLED REWARD, it will sum M157, O157, Q157.

 

As I can finally explain, these terms "INTEREST PAYMENT" or "REWARD" will decide which of the following formulas 1 or 2 should be used to result in the column "CREDIT AMOUNT"