Forum Discussion

NancyNN's avatar
NancyNN
Copper Contributor
Sep 16, 2020

calculating percentages

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

But on expenses with a negative number it calculates incorrectly

Any suggestions?

Thanks,

Nancy

excel
Formulas and Functions

2 Replies

  • Rajesh_Sinha's avatar
    Rajesh_Sinha
    Iron Contributor
    Sep 17, 2020

    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.

Resources