Formulas, Functions, Formatting, Charts, Data Analysis, etc.
by snm4387 » Thu May 19, 2016 1:19 am
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!!
-
snm4387
- Rookie
-
- Posts: 3
- Joined: May 19, 2016
- Reputation: 0
- Excel Version: excel 2010
by ConneXionLost » Thu May 19, 2016 2:19 pm
How about:
- Code: Select all
=IF(E3="YES",(D3*G3)*J3,"")
Cheers,
-
ConneXionLost
- Regular
-
- Posts: 68
- Joined: May 9, 2013
- Location: Canada
- Reputation: 19
- Excel Version: 2003, 2010
by snm4387 » Thu May 19, 2016 5:24 pm
Thank you... it was easier than I thought. Only question would be is it possible to leave the answer cell blank if the control sell is blank instead of having it say 'FASLE' ? If not it is no big deal- would just be less confusing for anyone else using the same spreadsheet.
Thanks again!
-
snm4387
- Rookie
-
- Posts: 3
- Joined: May 19, 2016
- Reputation: 0
- Excel Version: excel 2010
Return to General Excel Questions
Who is online
Users browsing this forum: No registered users and 253 guests