G Guest Jan 20, 2004 #1 Can you tell me what program that was written for? The one with the #AND#? Thanks, CJ
H Harlan Grove Jan 20, 2004 #2 Can you tell me what program that was written for? The one with the #AND#? Click to expand... It's the logical AND *operator* in 123 and Quattro Pro (and perhaps others). The Excel formula =IF(AND(B2>5,B2<=10),B2*10%,0) translates into 123 as @IF(B2>5#AND#B2<=10,B2*0.10,0)
Can you tell me what program that was written for? The one with the #AND#? Click to expand... It's the logical AND *operator* in 123 and Quattro Pro (and perhaps others). The Excel formula =IF(AND(B2>5,B2<=10),B2*10%,0) translates into 123 as @IF(B2>5#AND#B2<=10,B2*0.10,0)
