View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bill Kuunders Bill Kuunders is offline
external usenet poster
 
Posts: 303
Default 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!