Quote Originally Posted by estige View Post
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?