Forum Discussion

Jared83's avatar
Jared83
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%;...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jul 28, 2021

    Jared83 

    Something like

     

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

SergeiBaklan's avatar
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.

Resources