Hello,

I've been struggling on this for a while,

I have an Aim and CurrentValue and a tolerance of 5%.

I am struggling on how to make a formula which makes it if the current is + or -5% of the Aim it says Within Tolerance (if Current = Aim it says 1)
Points of note, The aim is a static manually added number whilst CurrentValue sums up everthing in I:I

Example:

Aim: 1000
Current: 500
Boundary is:
- 950
+ 1050
Within Tolerance?: Yes, No, 1

In the example, since the current isn't within the boundary it would be No.

Sounds easy enough, I just can't figure it out in my tired state.