in D type this
=IF(AND(A10+B100,A10+B10<60),(IF(OR(C10="xo",C10= "ox"),385*8)))
in E type this
=IF(AND(A8+B80,A8+B8<60),(IF(OR(C8="xo",C8="ox"), 150)))
try with experimental values in A,B, and C
did you get the hang of nested ifs and use and and or;.
Rocempire wrote in message
...
Could anyone please write this formula for me.
If A+B is equal to or greater than 0 and less than 60 and C equals the
letters xo or ox then D equals 385x.8 and E equals 150
If you do this I wish I could be just like you :) Thank you very much
Roch Miller
|