show blank instead of #NUM

[mholmes]

I have a formula that is copied over multiple rows. Some of these rows don't have numbers so the formula shows #NUM. Instead of deleting the formula in those rows, is it possible to have the formula show nothing instead of #NUM? Thanks!


Marcus

 

[Aladin Akyurek]

On 2002-11-01 15:42, mholmes wrote:
I have a formula that is copied over multiple rows. Some of these rows don't have numbers so the formula shows #NUM. Instead of deleting the formula in those rows, is it possible to have the formula show nothing instead of #NUM? Thanks!


Marcus

What is the formula?

 

[mholmes]

=DATEDIF(NOW(),F3,"d")

 

[Aladin Akyurek]

On 2002-11-01 15:49, mholmes wrote:
=DATEDIF(NOW(),F3,"d")

=IF(F3,DATEDIF(NOW(),F3,"d"),"")

or, rather,...

=IF(F3,DATEDIF(F3,TODAY(),"d"),"")
This message was edited by Aladin Akyurek on 2002-11-01 16:10

 

[mholmes]

That's not giving back the same results as my formula.

 

[IML]

On 2002-11-01 16:13, mholmes wrote:
That's not giving back the same results as my formula.

How about
=IF(F3,DATEDIF(TODAY(),f3,"d"),"")
or
=IF(F3,F3-TODAY(),"")

 

[Aladin Akyurek]

On 2002-11-01 16:13, mholmes wrote:
That's not giving back the same results as my formula.

Which one? Why wouldn't it give same results?

The syntax for DATEDIF requires that...

=DATEDIF(Date1,Date2,Specs)

where Date1 < Date2.