Help please.
I have cell C2 as an option of either less then 1400cc, more than 2000cc or
a number in between.
I have cell D2 as 'Petrol' or 'Diesel'.
I have cell K2 as a mileage number (ie: 10).
Under certain conditions, I need to calculate the pence per mile for a given
mileage.

This is the function I have compiled:
=IF(C2<=1400,K2*0.09,IF(D2="Petrol",K2*0.11,IF(C2< =2000,K2*0.09,IF(C22000,IF(D2="Diesel",K2*0.12,K2 *0.16)))))

This function returns all correct answers unless I select petrol, with more
than 2000cc. It will not return K2*0.16 which is what I am after?

I have tried many times but I am stuck.

Please can anyone help with completing this nested function, or is there
another way of solving my requirements?

Many thanks,

Colin.
--
Q3PD