IF function – is there a way to avoid repeating formula November 22, 2023 by Tarik You can force an error like #DIV/0! and then use IFERROR, e.g. =IFERROR(1/(1/SUMIFS_formula),"")