On Jan 28, 2008 11:36 AM, Regina Henschel <[EMAIL PROTECTED]> wrote: > Hi Ain, > > Ain Vagula schrieb: > > Hi, I have a spreadsheet from > > http://www.passiv.de/04_pub/Literatur/PHVP2002/PHVP02.ZIP > > In sheet U_Werte, cell K140 it contains formula: > > > > > =IF(COUNTIF(G140:G142;"")=2;IF(ISTEXT(G140);MAX(1,95;25/G139);IF(ISTEXT(G141);MAX(1,25;25/G139);MAX(0,12*(G139/1000)^(-0,44);25/G139)));"") > > > > This should check, where is the x-mark in range G140:G142 and perform > > accordingly some simple calculations. In OO.o this formula all the time > > outputs empty result. I cannot check it in Ecxel (dont have), but I > think it > > should work because this data is very old and widely used and it has not > > changed in latest PHPP (Passivhaus Projektierungspaket) versions. > > > > Can you suggest why it is not working or recommend something that works > > similarly both in Excel and Calc? > > Instead of > COUNTIF(G140:G142;"")=2 > use > COUNTBLANK(G140:G142)=2 > > kind regards > Regina >
Does it mean, in OO.o COUNTIF handles only values? Can't this be enhanced in future? ain
