You can "nest" IF functions, so you could skip the current IF by
checking for 0.
Assuming that your date is in A5:
=IF(A5=0,"",[current if])
The "" piece inserts a null string if the test is true (which serves
to make the cell appear empty) - and note that there are 2 double
quotes in there and not 4 apostrophes.


On Jul 29, 11:03*am, John C <johnc@stateofdenial wrote:
What is your formula? And when the value is zero, what value are you
referring to?
--
John C

"Rebecca" wrote:
I have an if function that relies on dates... the formula works every time
unless the value is = 0 .. then it displays -1.13687E-13 as the value.... how
can i fix this?!?!