Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Outstanding help on my earlier post Thank you !! Now to take it a little
further, this will show how lame I really am. If the following is one condition In D Type =IF(AND(A10+B100,A10+B10<60),(IF(OR(C10="xo",C10= "ox"),385*8))) and I want to add in another condition like the following =IF(AND(A10+B1060,A10+B10<72),(IF(OR(C10="xo",C10 ="ox"),420*8))) and yet another condition like the following =IF(AND(A10+B100,A10+B10<60),(IF(OR(C10="xox",C10 ="oxo"),500*8))) and if I wanted to add over 50 different formulas like those above in D How do I work this ? also on the following formula in E type =IF(AND(A8+B80,A8+B8<60),(IF(OR(C8="xo",C8="ox"), 150))) C8 will never have to rely on A or B to achieve its Value just want to be able to change the xo, ox = 150 to maybe pdox, pdxo = 300 I also want to add this many different scenarios of this formula in E Now how did all of you learn this stuff !!! I know "read the excel book" I tried and .. trouble I could not do it !!!! Thank you for your help,,, If you only knew how many others you will be helping with these formulas... Roch Miller |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
How do I set more than 3 conditional formats in Excel | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
30 Day Aging Report Using Conditional Formating | Excel Worksheet Functions |