Thread: CF help please
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
j5b9721 j5b9721 is offline
external usenet poster
 
Posts: 63
Default CF help please

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)