Excel Formula Question
enter in G6
=IF(E6="",0,D6-B6)
This is assuming that the existing formual in G6 is something like =D6-B6
--
Greetings from New Zealand
"Lesa" wrote in message
...
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!
|