#DIV/0 error suppressed creates other errors

[Jared83]

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).

[#2 · Accepted solution]

@Jared83 

Something like

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

[#3]

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

[#4]

@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

not to show zeroes.