IF function

[Rebecca]

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?!?!

 

[John C]

What is your formula? And when the value is zero, what value are you
referring to?

 

[Reitanos]

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.

 

[David Biddulph]

OK, Rebecca, now you've got us interested. Is the next phase of the game
the one where we have to guess what your formula might be, or are you going
to give us a clue?

 

[David Biddulph]

Or, to put it another way, =IF(ABS(your_formula)<1.2E-13,42,your_formula)