Forum Discussion
Using Formulas (IFERROR?)
I am trying to figure out a way to use the same formula (or combined formulas we can use in each) that will return the % of change as either -100% if column B is 0 or 100% if column A is 0 but B is ...
Why are you trying to invent a new kind of percentage calculation?
The formula for percentage change is:
2027_Proposed / 2026_Budgeted - 1If you don't like the !DIV/0! error then amend the formula to this:
=IFERROR(2027_Proposed / 2026_Budgeted - 1,"not defined")
=IF(2026_Budgeted=0;"not defined", 2027_Proposed / 2026_Budgeted - 1)Instead of "not defined" you can use a text more suited to your data, e.g. "no budget in 2026"