Link to home
Start Free TrialLog in
Avatar of Frank .S
Frank .SFlag for Australia

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
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Frank .S

ASKER

ok thankyou and if i want the formula to be = either zero or nothing?
=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