IF(H4=0,“0”,100-((I4*100))/H4) works for me on one row. But i have 10 sheets with multiple columns i need to get rid of error and display a zero. So a conditional check for whole column would work. What is the syntax?
I’m trying to do it en mass instead of setting it for each cell. Suggestions?
IFERROR(expression,0)So i would highlight the column and set a conditional format → condition and paste that in? I did that and still have all the #div/0!
I thought it would be for an end result obtained from a column. Conditional formatting can’t change the result of a calculation, only suppress with the “Error” condition. Best use cell formatting: choose a font colour equal to your background colour (e.g. white) and as number format use [BLACK]General
Create a cell style with those two changes and apply that instead of hard formatting the cells, so you can easily switch colours or format by changing the style.
If I (in order to avoid C13 being 0) type =IFERROR((E13/C13100),0) in LO 4.3.6.2 it’s somehow transformed to =IFERROR((E13/C13100)0) and that error is shown. What happens to comma?
That’s not an answer to the question above, why add it as answer? Presumably your parameter separator is something different and the comma is your locale’s group (aka thousand) separator, maybe try ; semicolon instead.
I’d vote for your answer but I don’t hav e5 votes. I wrote here instead of posting another question. Thank you.