Percentage to a target function

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?

Or maybe =IF(A1<=B1,1,A1/B1*-1)

Originally Posted by estige

Or maybe =IF(A1<=B1,1,A1/B1*-1)

Thanks.

That works with the minus as a percentage, but when a value is lower than 3 the percentage stays at 100%

Any thoughts?

I thought that was what you meant by: "If the Value was 3 or below - it would be 100% above ..."
Maybe
=IF(A1<=B1,A1/B1,A1/B1*-1)