We help IT Professionals succeed at work.

excel 2016 - formula value error

excel value error
- hi experts i dont understand why i have this 'value' error, please assist
- all i want to do here is if there is no value, to show nothing otherwise show total of formula calculation
excel-wkbk-1-value-error-1.xlsx
Comment
Watch Question

Mechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
Commented:
Change your formula to use a comma instead of +
=IF(SUM(D21,D26)=0,"",SUM(D21,D26))

Open in new window


Excel doesn't know how to add an empty string, but SUM knows how to ignore it.
Frank .SBuilding Estimator

Author

Commented:
ok thankyou and if i want the formula to be = either zero or nothing?
byundtMechanical Engineer
Most Valuable Expert 2013
Top Expert 2013

Commented:
=SUM(D21,D26)         will return either 0 or a number
=IF(SUM(D21,D26)=0,"",SUM(D21,D26))         will return either a blank or a number