ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional formating in excel (https://www.excelbanter.com/excel-worksheet-functions/5841-conditional-formating-excel.html)

Rocempire

Conditional formating in excel
 
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



All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com