add error to excel formula when there is a negative number in the denominator

[dianaCatz]

I have negative numbers in some denominators so I need to use this formula (for money year 2 compared to year 1). How do i also add in an iserror so if there's a #value or NA it is blank?
=IF(FU7<0,((FV7/FU7-1)*-1),FV7/FU7-1)

[MrShorty]

I am not an accountant or anything similar, but my impression is that most people don't really like to use "percent change" of any kind when one value is positive and one value is negative. I expect that the "best formula" to use in this situation is whatever best reflects what "percent change" means to you when one value is negative and one value is positive.

[Croweater]

Notwithstanding the reply you've already received, I think the answer to your question is;

=IFERROR(IF(FU7<0,((FV7/FU7-1)*-1),FV7/FU7-1),"")