Forum Discussion

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
Dec 08, 2020
Emilie21 That would be =B1/A1-1, formatted as a percentage.
'
Or perhaps I don't follow.

Riny_van_Eekelen

Platinum Contributor

Dec 08, 2020

Emilie21 Perhaps like in the picture below:

FALSE means not more than 2% off

TRUE means more than 2% off

Emilie21
Copper Contributor
Dec 08, 2020
Riny_van_Eekelen I already have something similar that I'm using but I really need to show it in percentage, for example, for 204 000$ it has to show 2% and for the 205 000$ it has to show 2,5%. Also, the percentage doesn't need to stay in between -5% and 5%.

Emilie
- Riny_van_Eekelen
  Platinum Contributor
  Dec 08, 2020
  Emilie21 That would be =B1/A1-1, formatted as a percentage.
  '
  Or perhaps I don't follow.
  - Emilie21
    Copper Contributor
    Dec 08, 2020
    Thanks a lot! I hadn't seen it that way but it worked! 🙂