Show blank or zero

  • Thread starter Thread starter Clare
  • Start date Start date
C

Clare

Hi

I have the formula =(V4-U4) the two columns have dates in them. If V4 is
blank it returns an answer -39864. Could you tell me how to make this show
blank or zero when no date is in V4.

Thanks
 
Clare said:
Hi

I have the formula =(V4-U4) the two columns have dates in them. If V4 is
blank it returns an answer -39864. Could you tell me how to make this
show
blank or zero when no date is in V4.

Thanks
Click to expand...

If you are asking a question about Excel, you'll have better luck if you
post it in a discussion group for Excel.
Here's how to locate the discussion group you need.

As you appear to be using a web interface, try this:

http://www.microsoft.com/communities/newsgroups/en-us/

In the tree on the left, open English, then open Office and Desktop
Applications. In the Office and Desktop Applications
subcategory, find and open the subcategory for Excel, and find a group
there for your post.
 
Back
Top