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: [email protected] For additional commands, e-mail: [email protected]
