Round up formula

[Asw091]

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

Responses	Positive	93%	Need	Neutral	Negative
100	93	92%	0	6	1

<tbody>
</tbody>

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.