diference in transportcost

[Belleke]

See example
I am looking for a formula that calculates the cost under 15.000 km at 0.018 and the difference above the 15.000 at 0.022 and make a total

 

[ETAF]

you already seem to do that - BUT i would use a bracket whenever you have a + or - along with * /
((B10-15000)*D10)+(15000*C10))
as the order excel carries out these calculations can lead to wrong results
excels order of calc

The order in which Excel performs operations in formulas - Microsoft Support

In some cases, the order in which a calculation is performed can affect the return value of the formula, so it's important to understand how the order is determined and how you can change the order to obtain the results you want.

support.microsoft.com

BUT i get the same result with brackets
whats the issue

 

[Belleke]

Thanks for your response. I will check the original file

 

[Belleke]

This one workks

=IF(C2<=15000;C2*VLOOKUP(B2;A10:D12;3;0);(C2-15000)*VLOOKUP(B2;A10:D12;4;0)+15000*VLOOKUP(B2;A10:D12;3;0))

I want this something like this

=((B10-15000)*D10)+(15000*C10)

 

[ETAF]

sorry I'm not following what you want

 

[GraH - Guido]

What about

=MAX(0;(B10-15000)*D10)+(MIN(B10;15000)*C10)

Year	KM	0 -> 15000 km	+15000 km	Total
2021​	17509​	0,018	0,022	325,198​	325,198​		=MAX(0;(B10-15000)*D10)+(MIN(B10;15000)*C10)
2022​	22173​	0,019	0,022	442,806​	442,806​
2023​	12944​	0,024	0,028	310,656​	310,656​