MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Null values


Posted by Donna D. on November 12, 2001 10:56 AM

I have a formula that checks the values of another column and that does some calculations. I want to first check to see if the field in the other column is empty, then do my calculation. If the field is empty, I want to leave the value blank, otherwise put the value in the field. My formula is: =E3-TODAY()

What I want would be something like

if E3 is null, then "", else =E3-TODAY()


Posted by Barrie Davidson on November 12, 2001 11:03 AM

=IF(ISBLANK(E3),"",E3-TODAY())

Regards,
Barrie
Barrie Davidson

Posted by Donna D. on November 12, 2001 11:03 AM

Nevermind. I figured it out.

Asnwer is: =IF(E3 <> "", E3-TODAY(),"")

Thanks,
Donna