Hi! I'm using OpenOffice.org 1.1.5 (slow PC from 1998, if anyone wonders why), but that shouldn't have anything to do with my question.
When answering someone elses post quite a while ago, someone gave me a tip that I have forgotten about now and I can't find that post. I have tried to search for it, but I can't find anything relevant to write in the search dialog. Either I get too many hits or nothing at all... So maybe someone can give me that tip again if I ask nicely... The problem is when you do something liuke the following example: A1 contains nothing. B1=A1 Now B1 shows 0. If A1 is nothing, I want B1 to show nothing... So I always solve this by this simple formula for B1: =IF(A1="";"";A1) Then someone told me that there is a better way to do this, but I can't remember right now what it was.... I realize that this will also work: =IF(ISEMPTY(A1);"";A1) But I am not sure if that was the tip... but maybe it was... Still, if there is a better way, please let me know! Regards Johnny
