Frank .S
asked on
excel 2016 value error_1
Try:
=if((e36+k36)=0,"",E36+K36 )
The Sum() function is used to sum a range of cells.
=if((e36+k36)=0,"",E36+K36
The Sum() function is used to sum a range of cells.
I would suggest that either E36 or K36 has a text value which cannot be used in a sum.
E36 appears to have a number but what is in K36? It looks blank but if it is a formula that returns "" then it would be classed as text.
Looking at your other question, I assume you have this formula (or similar) in K36:
=IF(SUM(S7:S26)=0,"",SUM(S 7:S26))
Because column K has no entries the SUM gives 0 so will give the "" which is causing the error in the comparison with E36.
You can get round it though, but the other way to what is suggested by the comments above. SUM function actually ignores text but by including the + within the sum it is doing the + first and getting an error. Try this instead:
=IF(SUM(E36,K36)=0,"",SUM( E36,K36))
E36 appears to have a number but what is in K36? It looks blank but if it is a formula that returns "" then it would be classed as text.
Looking at your other question, I assume you have this formula (or similar) in K36:
=IF(SUM(S7:S26)=0,"",SUM(S
Because column K has no entries the SUM gives 0 so will give the "" which is causing the error in the comparison with E36.
You can get round it though, but the other way to what is suggested by the comments above. SUM function actually ignores text but by including the + within the sum it is doing the + first and getting an error. Try this instead:
=IF(SUM(E36,K36)=0,"",SUM(
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi there! :)
In addition to the points mentioned about your usage of SUM() above, I would recommend you put everything into an IFERROR formula. I find it a good practice.
Example: =IFERROR(IF(SUM(E36,K36)=0 ,"",SUM(E3 6,K36)),"N A")
In addition to the points mentioned about your usage of SUM() above, I would recommend you put everything into an IFERROR formula. I find it a good practice.
Example: =IFERROR(IF(SUM(E36,K36)=0
Usage of IFERROR is only good practice if you can be certain of the errors that could occur and have allowed for them. If not then it will mask all errors and you may not get the result you're expecting.
=IF((E36+K36)=0,"",(E36+K3