Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. damian2013

    how many more sales to hit target percentage

    Thanks All liked the roundup
  2. damian2013

    how many more sales to hit target percentage

    so cells A1 = saves of 13 B1 = loss of 4 C1 = current save rate = =A2/SUM(A2:B2) = 76.47% D1 = target 81% E1= number of saves needed to hit the 81% target
  3. damian2013

    how many more sales to hit target percentage

    ok format went messy sales target = 81% current save = 13 (Variable daily) current losses = 4 (Variable daily) current save rate = 13 saves / 17 total loss & saves = 76.47% I need a formula to tell me how many more saves are required againts the total number of saves and loss to hit the target...
  4. damian2013

    how many more sales to hit target percentage

    Hi I'm trying to use excel to tell me how many more sales are needed to hit the 81% target. the formula also needs to taken in loss leads as if this increases the more sales required. sales loss leads month todate target sales needed 13 4 76.47% 81.00% thanks

Part and Inventory Search

Back
Top