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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
