#N/A not working in IF statement

Originally Posted by Turnipboy

Hi,

I have a graph which pulls its data from an x and y column each 200 cells long. However sometimes not all 200 rows are used but the graph is still looking at all 200 rows, so to stop the scale being messed up I put #N/A in these cells and the graph ignores them. However taking the next step, when I put the #N/A in an IF statement so the the cells equal #N/A when not required the graph goes funny and starts ignoring the x values and plots integer values instead on the x axis! How can I stop the graph's scale being messed up like this?

I have checked cell formatting and both times the type is general.

Hi,

how are you making the #N/A

If you are using "#N/A" then you need to remove the quotes and use #N/A

does this help?
---

Originally Posted by Turnipboy

Thanks, that did the trick (I was using "#N/A"

good to see it worked for you, and thanks for the response.

---