calculating percentages

Copper Contributor

I am trying to calculate percentage change from last fiscal year using (G2-F2)/F2 on revenue

NancyNN_0-1600281171275.png

But on expenses with a negative number it calculates incorrectly

NancyNN_1-1600281340360.png

Any suggestions?

Thanks,

Nancy

2 Replies

@NancyNN 

Try

 

=(G2-F2)/F2*SIGN(F2)

@NancyNN ,,,

 

  • Use  this Formula:

=(G2-F2)/ABS(F2)

 

   
-2675122.917603
   

 

Note: When you enter (267), Excel will convert it as -267 ( the rule,, value in parenthesis is negative value ). Cell format is GENERAL.