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 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