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

 2016
 Platform

 Windows
I'm trying to write a formula which returns a percentage value based on the IF statements below... it's the 'progressive' increase I can't master
A1 is a number I manually enter. It will only be a whole number!
if A1 is:
maabadi helped me yesterday with similar problem but this one is harder
A1 is a number I manually enter. It will only be a whole number!
 if A1 under 1 = 0%
 if A1 over 200 = 10%
if A1 is:
 between 1 to 5 = then the result should be a progressive range 1% to 3%.... so...
 if A1 was 1 then the result would be exactly 1.00%
 if A1 was 3 (i.e. in the middle of 1 to 5) then the percentage would be in the middle of 1% and 3% i.e. exactly 2.00%
 if A1 was 5 then it would be 3.00%
 if A1 was 2 or 4 then it would be a fraction percentage either 1.5% or 2.5%
 between 6 to 50 = progressive range 4% to 6%
 if A1 was 6 then result if 4.00%
 if A1 was 11 then the result would be around 4.25% (i think.. working that out in my head)
 between 51 to 200 = progressive range 7% to 9%
 if A1 was 200 then 9.00%
 if A1 was 201 then 10.00%
 if A1 was 199 then ever so slightly less than 9%
 if A1 was right in the middle of 51 and 200 then it would be 8%
maabadi helped me yesterday with similar problem but this one is harder