Ask Your Question

In a spreadsheet formua, if one of the fields has no data in it, how do i get a value rather than #Value!

asked 2019-09-12 16:54:57 +0200

WallyC gravatar image

updated 2019-09-12 17:02:29 +0200

Formua returns a value of #Value!

edit retag flag offensive close merge delete



And the formula expression is ...? And which cell is empty (has no data)?

Please edit your question to provide the details. Thanks.

erAck gravatar imageerAck ( 2019-09-12 17:22:54 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-09-14 09:25:43 +0200

Antonio52 gravatar image

Make sure that the so called empty field is indeed empty (clean). Maybe it is formatted as a non value like text. Try typing in a zero (0) and see what happens.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-12 16:54:57 +0200

Seen: 39 times

Last updated: Sep 14