Percentage Calc question

[Wayne_Sadler]

Hello everyone I have a brief question to ask.

I would like to be able to calc the remaining percentage in E5 to that of D5 which should auto calc at 52.56%, you will note I tried in E6 with the formula showing in the image but I get -52.56.

So if anyone knows the answer please could you advise, thank you.

Any advise would be most appreciated and welcome.

Thank you kindly in advance.

 

[Joe4]

Just flip the order of your formula and get rid of the multiplication, i.e.

=(B5-C5)/B5

and format the cell as a percentage.

 

[Micron]

C5-B5; you are subtracting a larger number from a smaller one. Reverse them? Or subtract 47.44% from 100%

 

[Scott Huish]

=1-D5

 

[Wayne_Sadler]

Thank you Joe4 it worked a treat.

And those who contributed to aid in solving the problem.

 

[Joe4]

You are welcome!
Glad we were able to help!

As Scott shows, there are multiple ways to get to that answer.