Jun 02 2022 10:10 AM - edited Jun 02 2022 10:12 AM
Hi,
I'm looking for a way to avoid plotting errors and zero values in Scatter Plot. I have a big chunk of values (populated using equations), 1000 rows, and 4 columns. Some of the cells (random) have either zero value or error value. I need to figure out a way not to plot those errors and zeros. I cannot use the option that hides all the zero values in that tab because there are other tables some cells have zero values and I need those zeros. I know the following equations - IF(equation=0,"") and IFERROR(equation,""). But is there a way to combine IF and IFERROR? I tried to use IF(And(.... but that didn't work. Any ideas? Also, I can't use any macro.
Jun 02 2022 12:49 PM