View Single Post
  #2   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default

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