Hi there, I am having a bit of an issue with if statements surrounding equations.
I have columns in a table which calculate percentages. I also have graphs that plot the data automatically.
The thing is is that the graphs have been plotting the equations as 0 values. It continues to do this with conditionally formatting the cells to display nothing. So I've tried to make the cell's display 0 values as #N/A.
The original formula is just a basic dividing equation: =B6/N12
Which ends up displaying 0% if there is no data to work with, and will display the correct percentage when there is data available, i.e. 83.3%
So I altered it with an IF statement to try and make 0's display #N/A which looks like this: =IF(B6/N12,0,NA())
Now this works when the equation has no data to work with, but when there is data to calculate, the percentages displays as 0 no matter what.
From what I can see all it should be doing is checking whether or not B6/N12 = 0, if so display #N/A. But when B6/N12 does not = 0, display the correct data. But in my case it's not working that way.
The main issue is that my line graphs have the cells pre-set, and all the cells are equations, so when the data is displaying 0's, it will plot them. The only way to get around it that I have found is to display 0's as #N/A, which has worked with other sets of data, just not this one.
Any support would be greatly appreciated.
Cheers,
- Sam
Bookmarks