Percentage of change with zero value in one cell

[rjrsn]

Good Day to all:
I have this scenario and I've looked at other posts in this and other forums and can't put my finger on the solution. My example is below:

Column E = This year to date information
Column F = Last year to date information

F52= 0 no activity for the previous year
E52= 7 increased activity for this year
Formula
=IFERROR((E52/F52)-1,0)

This returns a zero right now.
How can i change this to give me true percentage of the difference in the calculation? My thoughts are that it should show 700% and not zero as it does now. It must also give the actual percentages when there is no zero value involved.
Any help would be appreciated.
Thanks Bob Reynolds

 

[Andrew Poulsom]

Wouldn't that be?

=IFERROR((E52/F52)-1,E52)

 

[rjrsn]

Andrew thank you so much. It really helps to have a different eye look at it. I've pulled what little hair I have left out, and your answer solved my issue. Thanks