Forum Discussion
Jared83
Jul 28, 2021Copper Contributor
#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%;...
- Jul 28, 2021
HansVogelaar
Jul 28, 2021MVP
Jared83
Jul 28, 2021Copper Contributor
Thank you so much!!!!!!!!HansVogelaar It works perfectly