Conditional formating in excel

R

Rocempire

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+B10>0,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+B10>60,A10+B10<72),(IF(OR(C10="xo",C10="ox"),420*8)))

and yet another condition like the following
=IF(AND(A10+B10>0,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+B8>0,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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top