I am trying to find the formula in cell B1
Example 1
eg If cell A1 has value 5
Deduct 1
=4 then divide 100/4 =25
Then deduct 25 from 100 = 75
Then add 4 +(75% of 4)
Answer would be 7
Example 2
eg If cell A1 has value 11
Deduct 1
=10 then divide 100/10 =10
Then deduct 10 from 100 = 90
Then add 10+(90% of 10)
Answer would be 19
Hope this makes sense
Example 1
eg If cell A1 has value 5
Deduct 1
=4 then divide 100/4 =25
Then deduct 25 from 100 = 75
Then add 4 +(75% of 4)
Answer would be 7
Example 2
eg If cell A1 has value 11
Deduct 1
=10 then divide 100/10 =10
Then deduct 10 from 100 = 90
Then add 10+(90% of 10)
Answer would be 19
Hope this makes sense