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

    Jared83 

    Something like

     

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

Resources