Formula

MrSpud

New Member
Joined
Jun 21, 2008
Messages
10
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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,010
Office Version
  1. 365
Platform
  1. Windows
How about
=(1+(100-(100/(A1-1)))/100)*(A1-1)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,010
Office Version
  1. 365
Platform
  1. Windows
Or slightly simpler
=(2-(1/(A1-1)))*(A1-1)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,010
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,108,501
Messages
5,523,293
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top