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? ain
