conditional formulas in excel
 

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

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

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
"R.VENKATARAMAN" wrote:

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