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

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

Forum Discussion

Copper Contributor

Jul 28, 2021

Solved

#DIV/0 error suppressed creates other errors

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

excel

Formulas and Functions

HansVogelaar
Jul 28, 2021
Jared83

Something like

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

3 Replies

SergeiBaklan
Diamond Contributor
Jul 28, 2021
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.
HansVogelaar
MVP
Jul 28, 2021
Jared83

Something like

=IFERROR(MIN(F99/F98,100%),"")
- Jared83
  Copper Contributor
  Jul 28, 2021
  Thank you so much!!!!!!!!HansVogelaar It works perfectly