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 ...
Hello!
Your Formula is OK. Just insert 1 instead of "0.0"%. And apply the percentage format from the number group of the Home tab if is not applied yet.