Hi All,

I am looking to have a small excel function that would calculate a percentage to target. If the number is above the target, it should show as a negative percentage.

I.e.

Value
A1 = 18.3

Target
B1 = 3

Therefore in
C1 = should show that because 18.3 is way over "3" the target, it should be in a negative percentage of the target. If the Value was 3 or below - it would be 100% above if you see where I'm coming from.

Any thoughts?