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...

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

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