Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I set more than 3 conditional formats in Excel | Excel Discussion (Misc queries) | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |