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?