Ask Your Question
2

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

Comments

2

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
1

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

Stats

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

Seen: 39 times

Last updated: Sep 14