# Formulae - how many more to reach a certain percentage?

1. ## Formulae - how many more to reach a certain percentage?

Hi chaps,

Helped me loads in the past and hope you can again!

What formula can i use to find out the deficit to reach a certain percentage?

EG,
Calls = 100
Sales = 10
Current % = 10%
How many more sales would i need to reach 17%

So i know the calls, sales & current % but need a formula to work out how many more sales required to reach 17%?

Thanks!

2. ## Re: Formulae - how many more to reach a certain percentage?

If those values are in A1:A3 and you have 17% in B1, then:

=(A1*B1)-A2

shows how many more sales you need.

3. ## Re: Formulae - how many more to reach a certain percentage?

that would only work (I think) if you were assuming new sales were based off existing calls though, correct ?

else if you're basing additional sales off new calls then you would (at best) have made 7 more calls to make 7 more sales... ie 107/17 -> 15.89%

I don't have an answer, above my head I'm afraid, the above was more of a question to OP:

"are there rules in play regards from where in terms of calls additional sales are allocated ?"

4. ## Re: Formulae - how many more to reach a certain percentage?

of course!!

Thank you so much. i should have got that one!!

##### Users Browsing this Thread

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