#DIV/0 error suppressed creates other errors

New Contributor

I have used =IFERROR(F99/F98;"") to create a blank cell when the usual #DIV/0 error shows. However now I have had to create a separate formula which pulls from that cell which is =IF(D203>100%; 100%; D203) since I need to keep values that do populate in D203 to be limited to 100%. However the problem is that these second formulas somehow keep showing 100% when the D203 cell is ""(Blank).

3 Replies


Something like



Thank you so much!!!!!!!!@Hans Vogelaar It works perfectly


As variant


instead of using D203

Or in D203


and apply custom number format to it


not to show zeroes.