Need to calculate survey count

[dharrier]

I need to figure out how many perfect 100pt surveys are needed to reach the minimum goal of 95.51. In this example the current score is above 95.51 so I want to show a 0 value. If the score was say a 94.00 I want to calculate how many perfect 100pt surveys would be needed to get to the goal of 95.51. What would be a formula to use if the values were in columns A:F?

Current Score
96.42857143

Minimum Goal
95.51

How far off from Goal
-0.918571429

Total Survey Points
1350

Number of Surveys
14

Number of Perfect 100pt surveys needed
=??

[p24leclerc]

assuming your data starts in column A thru F, and that row 1 hold the titles, the your data are in row 2.
try this formula in cell F2:

Please Login or Register  to view this content.