Forum Discussion
Solved
Multiple IF function
I am trying to apply appropriate commissions based on finding "CR" in a column. So far, I have: =SUM((ISNUMBER(SEARCH("CR",D3))*(I3*0.65))) - which if it finds CR in field D3, it multiples field ...
Another less straight forward solution:
=(1-MMULT({0.35,1},COUNTIF(D3,{"*CR*";"*INV*"})))*I3
Hi
Straight forward:
=IF(COUNTIF(D3,"*CR*"),0.65,1)*I3
Less straight forward:
=(1-COUNTIF(D3,"*CR*")*0.35)*I3
- Thank you so much for the quick reply! Amazing that I have spent hours trying to figure this out! Thank you! :)
