Great suite - Thanks.
I love to hide the "0" value in cells yet to be populated and to do so I
use the =IF(Target Cell>0;Actual Formula;"") setup.
This works well for me upon the Target Cell being the result or a manual
entry.
However, this doesn't work when the Target Cell contains a formula. ( I
appreciate that the formula setup as above is correct and that it now
recognizes that the Target Cell is populated so is ">0" - just that
viewed in real life - no actual value yet exists.)
Maybe there's a way of re-addressing the value "0" in the 1st part
though it would be nice for a private user to be able to keep their
formulas simple.
So - not necessary a fault or bug or anything at all - just a thought in
case it's possible.
--
Regards
Frank
SnapafunFrank
facebook.com/JanFrankBreezie
