CF help please

  • Thread starter Thread starter j5b9721
  • Start date Start date
J

j5b9721

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)
 
The problem that I have is the formula is copied into cell EC6 as a
"Conditional Format - Condition 1" as this....
=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 the cell is copied down the page (even a new blank page) it changes
from that formula to this, at EC100,EC101, ect... (to this error)
=CE101="" ""
OR(EC100<=-5%,SUM(DX100,EC100)<=-5%,SUM(DW100:DX100,EC100)<=-5%,SUM(DV100:DX100,EC100)<=-5%)

I have tried it on different versions of excel also... excel 2000 win xp,
excel 2007 Vista, with the same affect taking place when its coppied below
line 100. I can only assume the formula string is to long.
 
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!
 
well it is right... Just copying the formula into a cell does work for me
also. Did you copy into "conditional format - condition 1"???

If "yes" I may have to try again reloading the software and try it again,
but trying this on 2 different computers I dont why its happening to me.
 
I reloaded my software... and have the same problem again in Conditional
Format -Condition 1 . But this time I also tried to copy your string into
cell CE300 as Conditional Format - Condition 1 selecting the "Formula Is"
section, but it would not paste into the Condition 1 box at all.

Thats why I think the string is to long, and needs to be shorter.
 
Back
Top