Hello,
Im trying to calculate a way for me and my colleagues to know how many remaining 5s we need to reach our target %. Since the target is 88% the only input that brings it up is the input 5 since input 4 is valued at "75%". Ive tried solving this for a few hours but i just cant wrap my finger around it
A = Categories
B = Input 1 worth 0
C = Input 2 worth 0,25
D = Input 3 worth 0,5
E = Input 4 worth 0,75
F = Input 5 worth 1
G = Current % (C-F Row 3/I)
H = Goal %
I = Total Input (C-F Row 2)
J = How many of Input 5 i need to reach Goal %
Row 3 is the Value of the inputs
Row 4 is the calculated value (Row2*Row3)
I Hope what im trying to make is possible and it kind of made sense. Thanks for the help!
Im trying to calculate a way for me and my colleagues to know how many remaining 5s we need to reach our target %. Since the target is 88% the only input that brings it up is the input 5 since input 4 is valued at "75%". Ive tried solving this for a few hours but i just cant wrap my finger around it
A = Categories
B = Input 1 worth 0
C = Input 2 worth 0,25
D = Input 3 worth 0,5
E = Input 4 worth 0,75
F = Input 5 worth 1
G = Current % (C-F Row 3/I)
H = Goal %
I = Total Input (C-F Row 2)
J = How many of Input 5 i need to reach Goal %
Row 3 is the Value of the inputs
Row 4 is the calculated value (Row2*Row3)

I Hope what im trying to make is possible and it kind of made sense. Thanks for the help!
