help with a formula

R

robc

I am realitivly new with doing formulas with excell any help any one can give
me would be apreciated.
this is the formula i created:
cell y9 =IF(V9>0,IF(V9=C9,0.5,(V9-G9)*0.1)+IF(D9=V9,0.1),"")

I need to adjust it to get my desired results here is what each cell
represents:
Y9= sales person's comision per unit
v9= Price that salesperson sold the unit at
c9= the list price
d9= the lowest amount they can sell the item for
g9= our cost for the unit sold
here are the parameters and results that I need to produce:
if the product is sold for list price(c9) then thier comision is .50(y9)
if the product is sold for lowest possible price(d9) then thier comision is
..10(y9)
if the product is sold for somewhere between list price(c9) and lowest
possible price(d9)then thier comision is the 10% of the difference between
price they sold it for(v9) & our cost for the unit sold(G9) so (v9-g9)*.10
another parameter is their lowest possible commision can be .10

let me give some exaples of my desired results
if
c9=52
d9=49
g9=47.50
if v9=52 then y9 should = .50, if v9=51 then y9 should =.35 if, v9=50.50
then y9 should =.30, if v9=49 then y9 should = .10
Again any help would be verry much apreciated
 
L

Luke M

=IF(V9<=0,"",IF(V9=C9,0.5,IF(V9=D9,0.1,MAX(0.1,(V9-G9)*0.1))))

This meets all your criteria and examples, and has a clause for making sure
commision is never lower than 0.1
 
R

robc

thanks so much luke it worked perfectly
Rob

Luke M said:
=IF(V9<=0,"",IF(V9=C9,0.5,IF(V9=D9,0.1,MAX(0.1,(V9-G9)*0.1))))

This meets all your criteria and examples, and has a clause for making sure
commision is never lower than 0.1
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top