conditional formulas in excel

[Guest]

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

 

[R.VENKATARAMAN]

in D type this
=IF(AND(A10+B10>0,A10+B10<60),(IF(OR(C10="xo",C10="ox"),385*8)))

in E type this

=IF(AND(A8+B8>0,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;.

 

[Guest]

Hi,
A small correction noticed.
D =if(and(A+B>=0,A+B<60),if(or(C="xo",C="ox"),385*.8,""),"")
This gives the result that if the codition is not satisfied ,D will be
blank(''")

E=if(and(A+b>=0,A+B<60),if(or(C="xo",C="ox"),150,"'),"")
Here also it is presumed that if the condition is not satisfied
,E=""(ie,blank)
I hope this will meet your requirement.
Thank you,
K.S.Warrier