Formula Needed

[Wilfred555]

Hi,

Heres my problem,

CSS = P divided by S.
PS Required is a number that needs to be added to both S and P to achieve target of 83%

The answer to the below = 5. But i dont know how to get it using a formula
(If 5 is added to S and P both, S will become 36 and P will become 30; 30/36 = 83.33%)


Name S P CSS Target PS required
Adam 31 25 80.65% 83.00% ?

Thanks !

 

[R_Stephens]

Hi Wilfred555,

Assuming your S value is in B2, your P value is in C2 and you are wanting to round to the nearest whole number (as it appears you did above) try the following.


=ROUNDUP(((0.83*B2)-C2)/0.17,0)

Hope it helps

Richard

 

[fridgenep]

Hi,

try this:

=VERGLEICH(C5;(24+ZEILE($A$1:$A$100))/(30+ZEILE($A$1:$A$100));1)-1

pay attention: you have to use Strg+Shift+Enter to make the formula works...

Use:
Vergleich() = Match()
Zeile() = Row()
; = ,

In my example is range C5 which has the Value of the PS required.

 

[Krishnakumar]

Cross Post

 

[Wilfred555]

Thanks

Thanks Guys !

Got the Answer !

Wilfred