Forum Discussion
JyrkiT
Apr 16, 2020Copper Contributor
Excel suppressing zero problem almost solved ...but a serious setback, please help.
Hello, I'm using Excel 2016 in Finnish and encountered a problem with empty cells treated as zeros in my sheet. I'm trying to create a simple way to visualize a set of numbers fed into the sheet as...
Riny_van_Eekelen
Apr 16, 2020Platinum Contributor
JyrkiT Not sure I follow everything, but have you selected the option to show empty cells as "connect data points with line"? See the picture below.
- JyrkiTApr 16, 2020Copper Contributor
My problem was solved when I changed the original formula
=JOS(B17="";"#PUUTTUU!";B17*2)
to the format
=JOS(B17="";#PUUTTUU!;B17*2)
Some metadata must've come with the first version that confused the program. I got this hint from a programmer friend who absolutely knows nothing about excel but a lot about problemsolving.