General discussion

Locked

Excel #values!

By Whatme? ·
Is there a formula to "not report" a #value? Example
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.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel #values!

by DKlippert In reply to Excel #values!

=IF(ISERROR(B1-A1),"",B1-A1)

If there is any error value, this formula returns "" (there is no space between the quotes). Otherwise the formula is computed.

Collapse -

Excel #values!

by Whatme? In reply to Excel #values!

Thanks.
merv

Collapse -

Excel #values!

by Whatme? In reply to Excel #values!

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums