BrutalLogiC
Active Member
 Joined
 Feb 26, 2006
 Messages
 255
 Office Version

 2016
 Platform

 Windows
Help please
A1 is a value
B1 is the formula I am trying to write
If A1 is above zero and up to and including 200,000 then I want the percentage to be 2%
If A1 is 20,000,000 or more then I want the percentage to be 15%
but how to have a 'progressive' result in B1 based on the value in A1?
for example, if A1 was exactly in the middle of 200k and 20m (which would be 10,100,000) then the percentage would be 8.5% (halfway between 2% and 15%)
A1 is a value
B1 is the formula I am trying to write
If A1 is above zero and up to and including 200,000 then I want the percentage to be 2%
If A1 is 20,000,000 or more then I want the percentage to be 15%
but how to have a 'progressive' result in B1 based on the value in A1?
for example, if A1 was exactly in the middle of 200k and 20m (which would be 10,100,000) then the percentage would be 8.5% (halfway between 2% and 15%)