j5b9721
Guest
Posts: n/a

 28th Jul 2009
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(DW6X6,EC6)<=-5%,SUM(DV6X6,EC6)<=-5%),OR(MAX(DT6W6)>4.5%,MAX(DP6,DY6,EH6)>-3.5%),AND(EC6<1%,OR(EC6<-5%,SUM(DX6)<=-5%,SUM(DX6,EC6)<=-5%,SUM(DW6X6,EC6)<=-5%))))

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

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

OR(MAX(DT6W6)>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(DW6X6,EC6)<=-5%)))) (one must be true)

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?TWFuTmVlZEhlbHA=?= Windows Vista Installation 2 31st Jul 2006 02:55 PM =?Utf-8?B?TWFuTmVlZEhlbHA=?= Windows Vista Installation 2 30th Jul 2006 09:31 PM PK Windows XP General 0 27th Aug 2004 12:02 AM =?Utf-8?B?UmFuZHk=?= Microsoft Access Macros 2 17th May 2004 07:16 PM -\$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM

Features