Sum empty cell returns #value (update)
Not sure if this has been ask before
I'm trying to have SUM of 3 components =SUM(H211-F211)*E211 when there's a component (square) that is empty it returns #value
How do I prevent this from happening?
Thank you for helping in advance....
Updated.... i tried =(H211-F211)E211 instead of =sum(H211-F211)E211 see attachment of error I still get #value error when I use formula C:\fakepath\value error Libreoffice 01-02-2019.JPG
/////////////////////////// updated
I found the solution .... by experimenting =IFERROR(SUM(H211-F211)*E211,0)
this replaced #value! (error) with 0.00 which i needed
=SUM(H211-F211)*E211isn't a sum of three components, but the product of a difference with a third operatand.The usage of SUM() is just an obfuscation in this case. You should better use
=(H211-F211)*E211.Check your "empty cells". They surely aren't empty, but contain formulae returning zero-length strings or whitespace - or the whitespace as direct content.