Hello,
I am trying to make things easier for me and my boss to track commissions. What I need is to multiply a dollar amount by a commission percent and then a second percentage but only if the control column indicates the sale was actually made.
My example:
IF E3=YES then (D3*G3)*J3 so basically if E3 says Yes then I want the $ multiplied by 9% and that answer multiplied by 33% When column E is Yes then: $100 x .09 = $9 $9 x .33 = $2
I have the formula for the numbers I just need to find out how to set the condition that it only computes it if column E says Yes.
I appreciate any help.
Thanks!!