Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Rocempire
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Conditional Formating csfrolich Excel Discussion (Misc queries) 2 January 17th 05 02:07 PM
How do I set more than 3 conditional formats in Excel Reefshark Excel Discussion (Misc queries) 1 January 17th 05 11:57 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM
30 Day Aging Report Using Conditional Formating Tiegris Excel Worksheet Functions 0 November 4th 04 10:07 PM


All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"