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…
I found the solution … by experimenting
this replaced #value! (error) with 0.00 which i needed