General discussion
| Thread display: Collapse - |
All Comments
Back to Software Forum
3 total posts
(Page 1 of 1)
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel #values!
A col,03/03/01 B col,03/05/01, C col =sum(B1-A1) . this returns the number of days = 2
If there are no entries in A1 or B1 it returns a #value. Is there a way to hide the #value if no dates are entered?
Same with a divide/0. I realize you can't but can that be hidden?
This conversation is currently closed to new comments.