Multiplication by negative value that should be positive
Posted on 2014-01-16
I need to calculate standart operating profit by dividing current year by prior year. Here is my formula:
=IFERROR(EG8/EN8-1,"") My issue is that if last year was negative and this year is positve, then the result is negative which is incorrect b/c there is a growth in the operating profit. How do I need to adjust the formula in order for my sign to flip to positive if last year data is negative.
For example: FY 2013 has $87,733 amd FY 2012 has -$43,267. The current answer is negative 302.8% but it should be positive (87,733 +43,267)/43,267