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 ...
What sort of errors are you trying to catch to show 0%? because the simpliest thing would be to change the iferror from 0 to 100 but I agree that simpliest isn't always the best so try this:
=IFERROR(IF(E152,(F152-E152)/E152,1),0)
note I rearranged the equation to remove that negative sign and got rid of the text "0.0"% in favor of just 0 and let your formatting handle it. I also just passed a value of 1 for the "100%" value.