Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|