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
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.