Problem resolving formula with IF function

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.

=if(M10="","",if(M10="No",0,if(O10<39,1.5,6)))

Originally Posted by brokenbiscuits

=if(M10="","",if(M10="No",0,if(O10<39,1.5,6)))

Thankyou ever so much - I appreciate it - been banging my head against the wall with it.