incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Barker <b.m.bar...@btinternet.com>
Subject Re: DDE linked cells fool the "=0" test, and dismay paintbrush
Date Mon, 12 Dec 2011 08:57:02 GMT
At 21:24 11/12/2011 -0800, Terry Noname wrote:
>What I tried before that was: [...] 
>=IF(TEXT(A3;"###.##")="";"value";"zero") which returns "zero" regardless

That's not surprising: TEXT(<zero>;"###.##") is ".", not the empty 
string that you appear to believe.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org


Mime
View raw message