Forum Discussion

Emilie21's avatar
Emilie21
Copper Contributor
Dec 08, 2020
Solved

I need a formula!

Hi,   I need to calculate something but I have no idea what formula I could use. Let's say my forecasted expenditures are of 200 000$ and my current forecast is of 204 000$. I need a formula that's...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Dec 08, 2020

    Emilie21 That would be =B1/A1-1, formatted as a percentage.

    '

    Or perhaps I don't follow.

Emilie21's avatar
Emilie21
Copper Contributor
Dec 08, 2020
Thanks a lot! I hadn't seen it that way but it worked! 🙂