Frank .S

asked on

# 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

- 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

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

=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

=IF(SUM(D21,D26)=0,"",SUM(

ASKER