#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

@Jared83 

Something like

 

=IFERROR(MIN(F99/F98,100%),"")

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

@Jared83 

As variant

=IFERROR(MIN(F(99/F98,1),"")

instead of using D203

Or in D203

=IFERROR(F99/F98,0) 

and apply custom number format to it

image.png

not to show zeroes.