![]() |
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