tag:blogger.com,1999:blog-3794737577784583819.post6280984441259373246..comments2023-10-25T04:38:36.360-07:00Comments on Excel Enthusiasts: That Blank LookBob DeLaMartrehttp://www.blogger.com/profile/03761089085420930697noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3794737577784583819.post-75727910198173489612009-06-11T08:32:44.782-07:002009-06-11T08:32:44.782-07:00DON'T use a space, use null:
=IF(A1>365,&qu...DON'T use a space, use null:<br />=IF(A1>365,"Data Error!","")<br />it's "" not " "<br /><br />The cell is also not blank as the post says, it's a zero-length string. They're different.<br /><br />Bob Umlas<br />Excel MVPAnonymoushttps://www.blogger.com/profile/16402244243307469692noreply@blogger.com