Hi

I have what seems to be a simple formula but I just can't resolve it. I've tried a number of permutations but can't get the formula to do what I want.

I've got this far;

=IF(M10="yes",6,0)+IF(O10<39,-4.5)+IF(M10="no",4.5,0)

What I want is the following logical formula;

If M10 equals "yes" and O10 is greater than or equal to 39 return a value of 6
If M10 equals "yes" and O10 is less than 39 return a value of 1.5
If M10 equals "no" return a value of 0

I'm sure this is easy and I will kick myself when I see it resolved.

Thankyou very much in advance.