In G6:
=IF(E6="",0,something_else)
--
Gary's Student
gsnu200703


"Lesa" wrote:

I am new to all of this and am having a VERY difficult time getting a formula
which explains the following: if E6 is BLANK then G6=0. I am working with
dates and my spreadsheet is calculating a negative number unless the "date
field" is populated.

Anyone help me out there?? Thanks!