IF function
 

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

IF function
 

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

IF function
 

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

IF function
 

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

"Rebecca" wrote in message
...
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?!?!

IF function
 

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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

"Rebecca" wrote in message
...
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?!?!