Walter Hildebrandt wrote:
Using 3.1 with WindowsXP If cell A1 is empty and =IF(A1;"") is in B1, B1 will have the word FALSE. What can be entered in B1 to get an empty B1 cell?
You don't say what you want in B1 if A1 is not empty. If you want B1 to be equal to A1 when A1 is not empty, then try: =IF(A1="";"";A1) --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
