If D2 is Petrol and C2 1400 e.g 2001 the 'IF(D2="Petrol' clause will be
executed and hence you will never get the corret result.

It is not clear (to me) what the rules are for commbination of capacity (cc)
and fuel type.

Do you need AND conditions e.g IF Petrol AND 2000?

What are K2 values for the following

Petrol Diesel
<=1400 0.09 0.09
<=2000 0.11 (?) 0.0(?)
2000 0..16 0.12

"q3pd" wrote:

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