I'm trying to prevent the sum cell from showing a large number when only one date is entered and the other is blank. Any help would be appreciated.
I'm trying to prevent the sum cell from showing a large number when only one date is entered and the other is blank. Any help would be appreciated.
What would you like to be shown instead? Nothing if both cells aren't filled in?
If so, try this:
=IF(COUNT(G2:H2)<2,"",G2-H2)
Or try
Formula:Please Login or Register to view this content.
This worked. Thank you for pointing me in the right direction.Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks