# Calculate percentile of two cells (must work with minus numbers)

1. ## Calculate percentile of two cells (must work with minus numbers)

Hello,

In cell A1 i have the number -20
in cell A2 i have the number 5
so the range of the two numbers is 25.

i would like B1 to have a formula that calculates 20% between the two numbers (-20 and 5)

thank you

2. ## Re: Calculate percentile of two cells (must work with minus numbers)

Formula:
`Please Login or Register  to view this content.`

3. ## Re: Calculate percentile of two cells (must work with minus numbers)

Seems like it should be a simple proportionality: (A2-A1)/(1-0)=(x-A1)/(0.2-0) then solve for x.

4. ## Re: Calculate percentile of two cells (must work with minus numbers)

ollys worked great. cheers

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1