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 Katie,
Perhaps something like
=I3*IF(ISNUMBER(SEARCH("CR",D3)),0.65,1)- Thank you, thank you for the quick reply! That is exactly what I needed! :)
