I have the following formula in my worksheet and I want to use a sparkline to show the trend. The formula returns a blank cell in case of an error value.
=IFERROR(C29/(C3-C33);"")
My sparklines go down to 0 and I don't understand why. OK, since the cell contain a formula it is not really blank but its value is not 0 either.
I would like the sparkline to show a gap in those cases. Is there a way to make it work?
Bookmarks