Please Note: that cell ce6 has the conditional formula, and cell EC7 is for
daily data log. So ce6 is coppied into ce8, ce10, ce12, ect... (down the
page)
But it it also does not matter how its coppied down the page. I tried
copping the cell directly from ce6 to cells below ce100 having the same
error. Its Very Strange!

"Simon Lloyd" wrote:


Whats wrong with the statement changing to EC100...etc do you want them
to always be DX6 etc?, other than that i cant see what you are getting
at?
j5b9721;433004 Wrote:
In CF I have this string, but its format to long to copy down the page.
Is
there a way I can shorten this statement?

=IF(CE7="","",AND(OR(EC6<=-5%,SUM(DX6,EC6)<=-5%,SUM(DW6:DX6,EC6)<=-5%,SUM(DV6:DX6,EC6)<=-5%),OR(MAX(DT6:DW6)4.5%,MAX(DP6,DY6,EH6)-3.5%),AND(EC6<1%,OR(EC6<-5%,SUM(DX6)<=-5%,SUM(DX6,EC6)<=-5%,SUM(DW6:DX6,EC6)<=-5%))))

When copied down the page (at line 100) it changed to this...
=EC101="" ""
OR(EC100<=-5%,SUM(DX100,EC100)<=-5%,SUM(DW100:DX100,EC100)<=-5%,SUM(DV100:DX100,EC100)<=-5%)


=IF(CE7="","", (command is needed... as it activates early)
AND(OR(
EC6<=-5%,
SUM(DX6,EC6)<=-5%,
SUM(DW6:DX6,EC6)<=-5%,
SUM(DV6:DX6,EC6)<=-5%), (one must be true)

OR(MAX(DT6:DW6)4.5%,MAX(DP6,DY6,EH6)-3.5%), (must be true)

AND(EC6<1%, (must be true)
OR(EC6<-5%,
SUM(DX6)<=-5%,
SUM(DX6,EC6)<=-5%,
SUM(DW6:DX6,EC6)<=-5%)))) (one must be true)


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (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=120233