Formula calculating two criteria and adding together

[Jon3sy]

Hi there excel gurus

How do I write a formula for an invoice that will calculate the following mileage:

mileage up to <=200km the rate is .50c, remaining mileage >200km rate is .35c - the formula will be in one cell looking at the quantity in the next cell. So for anything over 200km the formula will be adding two calculations together.

Hope I have explained my requirement correctly.

Many thanks

 

[Tetra201]

Is this what you need?

=MIN(A1,200)*0.5+MAX(0,A1-200)*0.35

 

[Jon3sy]

Wow, legend!! Speedy gonzalez, absolutely perfect - works a dream - very much appreciated Tetra201
Cannot thank you enough
Have a great day.