Round up formula

[Asw091]

Hello, I have a formula that is kind of working but is out.



[TABLE="class: grid, width: 50"]
<tbody>[TR]
[TD]Responses[/TD]
[TD]Positive[/TD]
[TD]93%[/TD]
[TD]Need[/TD]
[TD]Neutral [/TD]
[TD]Negative[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]93[/TD]
[TD]92%[/TD]
[TD]0[/TD]
[TD]6[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

The responses are Positive + Neutral + Negative and the results are calculated by Positive(B2) - Negative(F2) / Responses(A1).

The Formula for that is returning the correct result, but Need(D2) should still be showing 15, as it’s 93% I need, not 92%.

Te formula I’m using is D2 is (ROUNDUP(((LEFT(C1,2)÷100×$A2)−B2)÷(1−(LEFT(C1,2)÷100)),0)

Can anyone notice a mistake?

 

[Joe4]

I am not sure where you get 15 from, but perhaps this will help you identify your issue.

92% is really equal to 0.92. So I don't you want to divide by 100 and take the two left-most characters (it will return "0.0").
Break your formula down in smaller chunks like that to see what each part is doing and confirm it is doing what you want.

 

[Asw091]

Thanks for your response, I found out the Formula was trying to do -B2, not -(B2-F2).

Something so small eh.

Finished formula is (ROUNDUP(((LEFT(C1,2)÷100×$A2)−(B2-F2))÷(1−(LEFT(C1,2)÷100)),0)

Red marks the corrections.