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%)
Looking at this
=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)it seems that you can simply test for SUM(DV6:DX6,EC6)<=-5%) as you are
checking for any of the 3 conditions, if DV6 was empty or the sum was
not <=-5% then DW6:DX6...etc would be true and so on.

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)You can do the same for the above portion of the formula.


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