formula to calc fee at different rates

[COOT]

Knundrum... I need to calculate a final value fee of 13.25% of a sale price up to $7500, and then if the sale price is more than 7500 that additional sale price is calculated at 2.35%.

In example, I sell a product for 8500 (which would be shown in column K under OFFER). The final value fee in column M should calculate at 13.25% up to the $7500, the remaining $1000 would be calculated at 2.35% in column N. I can get the calcs to happen but I cant separate them. I keep calculating the whole thing at 13.25% or it calculates the whole thing at 2.35%. Im missing the right IF THEN somewhere.

if the sale is 7500 or less column N would remain at 0.

 

[Joe4]

For a value in cell G4, you can use this formula to do it all at once.

=(MIN(G4,7500)*0.1325)+(MAX(G4-7500,0)*0.0235)

If you wanted to break it into two, you would have this in cell M4:

=MIN(G4,7500)*0.1325

and this in cell N4:

=MAX(G4-7500,0)*0.0235

EDIT: I am not sure what value you are using in your calculations. If not G4, then simply change those references to the range you want.

 

[COOT]

For a value in cell G4, you can use this formula to do it all at once.

=(MIN(G4,7500)*0.1325)+(MAX(G4-7500,0)*0.0235)

If you wanted to break it into two, you would have this in cell M4:

=MIN(G4,7500)*0.1325

and this in cell N4:

=MAX(G4-7500,0)*0.0235

EDIT: I am not sure what value you are using in your calculations. If not G4, then simply change those references to the range you want.

the second formula is working but the first one is calculating at 7500 without a value... not sure im explaining it right. so with 0 as the value column n still shows $993.75.

 

[COOT]

the second formula is working but the first one is calculating at 7500 without a value... not sure im explaining it right. so with 0 as the value column n still shows $993.75.

hold it... its working now. ok sorry thank you!!!

 

[Cubist]

Try adding a check if G4 is blank.

=(G4<>"")*MIN(G4,7500)*0.1325

 

[COOT]

Try adding a check if G4 is blank.

=(G4<>"")*MIN(G4,7500)*0.1325

ooh there it is... good call that works swimmingly!

 

[Joe4]

You are welcome.
Glad we could help!