Finding the closest value...

[ChrisBurrows]

Hello all,

I need to retrieve either Value A or Value B depending on which is closer to Value C. I did find a way to do it.... but it utterly disgusts me and I can't shake the feeling, a more elegant solution exists.

Any help would be greatly appreciated.

[EdSabbath]

Check for:
Alterable Value C("Active") - Alterable Value A("Active") > Alterable Value C("Active") - Alterable Value B("Active")
then Alterable Value B is closer


Alterable Value C("Active") - Alterable Value A("Active") < Alterable Value C("Active") - Alterable Value B("Active")
then Alterable Value A is closer

Very simple

[King_Cool]

Two conditions:

If Abs( ValueC - ValueA ) < Abs( ValueC - ValueB )
--> Set Counter to ValueA

If Abs( ValueC - ValueB ) < Abs( ValueC - ValueA )
--> Set Counter to ValueB

...
Just from the top of my head, i have not tested this but think this should work.
I believe ther should be a way of doing this in just 1 Condition though.

[ChrisBurrows]

Thanks Ed, you're a life saver.

May the gods protect you from a sharp knife in a dark alley real soon.