conditional formulas in excel

[Rocempire]

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

 

[K.S.Warrier]

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