IF then statement in conditional format

[Parviz]

Hi,

I am trying to compute value based on the value of cell.
Like I would like to compute the DATEDIF if a cell is
blank/null such as

=IF(I4=" "), THEN DATEDIF(H4,NOW(),"d")>3

can this be done, if so, what is the correct syntax.

Thanks

 

[Don Guillett]

will this help?
=IF(OR(I4="",I4=" "),DATEDIF(H4,NOW(),"d"),"")

 

[Frank Kabel]

Hi
try
=IF(I4="",DATEDIF(H4,NOW(),"d"),"")

 

[Hayso]

=IF(ISBLANK(I4),DATEDIF(H4,NOW(),"d")>3)

 

[Guest]

Hi,

I tried that with a > 1 (2 or 3 for that matter) it always
says the condition is true.

What I did was

=IF(I4="",DATEDIF(H4,NOW(),"d"),"") > 1

any ideas?

Thanks

 

[Parviz]

Thanks, that seems to work

-----Original Message-----
=IF(ISBLANK(I4),DATEDIF(H4,NOW(),"d")>3)



.