| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using 2 cell CF conditions from different cells together
In cell A1 with CF Condition 2 is true.
In cell "B1 CF Condition 1" I need to add "A1 CF Condition 2" and this to it... OR(EU57:EX57<EY57),AVERAGE(EL57:EP57)<AVERAGE(EU57 :EY57)) do you have any ideas???? Thanks for looking & helping... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using 2 cell CF conditions from different cells together
Whats the formula in B1 CF Condition? j5b9721;461391 Wrote: In cell A1 with CF Condition 2 is true. In cell "B1 CF Condition 1" I need to add "A1 CF Condition 2" and this to it... OR(EU57:EX57<EY57),AVERAGE(EL57:EP57)<AVERAGE(EU57 :EY57)) do you have any ideas???? Thanks for looking & helping... -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=127633 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using 2 cell CF conditions from different cells together
Hi Simon...
B1 CF condition1 is... what I listed below I need to add "A1 CF Condition 2" and add this to it also... OR(EU57:EX57<EY57),AVERAGE(EL57:EP57)<AVERAGE(EU57 :EY57)) Condition 2 has ... a formula for price increase Condition 3 has ... has a bundle list tied to it "Simon Lloyd" wrote: Whats the formula in B1 CF Condition? j5b9721;461391 Wrote: In cell A1 with CF Condition 2 is true. In cell "B1 CF Condition 1" I need to add "A1 CF Condition 2" and this to it... OR(EU57:EX57<EY57),AVERAGE(EL57:EP57)<AVERAGE(EU57 :EY57)) do you have any ideas???? Thanks for looking & helping... -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=127633 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format a cell based on conditions in five different cells | Excel Discussion (Misc queries) | |||
| How do I format cells with conditions set on another cell? | Excel Discussion (Misc queries) | |||
| Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
| shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
| Count Cells if diff cell meets conditions | Excel Worksheet Functions | |||
Hybrid Mode
