New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Need last part of formula for figuring split commission.

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

Need last part of formula for figuring split commission.

Postby snm4387 » Sun Aug 21, 2016 5:04 pm

I have my basic formula and it is working great. Now I would like to go one more step. currently my formula is
=IF(D3="New",(E3*P3)*Q3)*1 - this is the amount in column S and then to total by employee I have =SUMIFS(S2:S152,N2:N152,"MG") which appears in column V
I would like to know how to add that if there is a value in column R the amount from the first formula needs to be split in half and added to the final total of the second formula.


D E N O P Q R S V
New $447.00 MG I 9% 33% JM $13.28 $253.48

column V is giving the total amount of earned commission for MG however, MG should only get 1/2 of amt in column S and JM should get the other half. There isn't always a value for column R and in those cases the amount in column V is correct.
Any help?
  • 0

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

Re: Need last part of formula for figuring split commission.

Postby Beamer » Sat Sep 03, 2016 12:12 am

Hi snm, try this in cell S3:-

Code: Select all
=(D3="New")*E3*P3*Q3/(1*(R3<>"")+1)
  • 0

Beamer
Excel Junkie
 
Posts: 217
Joined: Oct 3, 2014
Location: New South Wales, Australia
Reputation: 31
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 67 guests

cron