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 going to tell me in percentage if my current forecast is within 5% of my forecasted expenditures (so 190 000$ and 210 000$). In this case, the percentage should be 2% but I have no idea what formula I could use to achieve that.

Thanks in advance for the help!

Emilie

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.

5 Replies

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.

Forum Discussion

I need a formula!

5 Replies

Resources