New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Need help with formula

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Need help with formula

Postby 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!!
  • 0

snm4387
Rookie
 
Posts: 3
Joined: May 19, 2016
Reputation: 0
Excel Version: excel 2010

Re: Need help with formula

Postby ConneXionLost » Thu May 19, 2016 2:19 pm

How about:

Code: Select all
=IF(E3="YES",(D3*G3)*J3,"")


Cheers,
  • 0

ConneXionLost
Regular
 
Posts: 68
Joined: May 9, 2013
Location: Canada
Reputation: 19
Excel Version: 2003, 2010

Re: Need help with formula

Postby 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!
  • 0

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 49 guests

cron