Looks like my calculations today are kinda slow since im looking into improve or get some results. i have the following: name survey count current score failed survey good survey survey goal anderson haley 44 89.00% 4.84 ¿? 92.00% assuming that D2 is =B2-(B2*C2) and F2 is going to be the same and the only data to input are B2 and C2. how can i get E2. scores are yes=100% or no=0% so basically what im looking is to know if you are not on goal how many yes or 100% you need so you can be at goal.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

calculation based on results

Thread starter kx5470
Start date Jan 28, 2016
Tags

calculation formula logical formula results table

kx5470

New Member

Jan 28, 2016

Looks like my calculations today are kinda slow since im looking into improve or get some results.

i have the following:

[TABLE="class: grid, width: 400"]
<tbody>[TR]
[TD]name[/TD]
[TD]survey count[/TD]
[TD]current score[/TD]
[TD]failed survey[/TD]
[TD]good survey[/TD]
[TD]survey goal[/TD]
[/TR]
[TR]
[TD]anderson haley[/TD]
[TD]44[/TD]
[TD]89.00%[/TD]
[TD]4.84[/TD]
[TD]¿?[/TD]
[TD]92.00%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

assuming that D2 is =B2-(B2*C2) and F2 is going to be the same and the only data to input are B2 and C2. how can i get E2.

scores are yes=100% or no=0%

so basically what im looking is to know if you are not on goal how many yes or 100% you need so you can be at goal.