Excel Help! (percentage!!!)

[ssmacc]

Hello,

I've sure this is easy but it's driving me nuts!

I'm trying to calculate the percentage if we know how many are missing out of a total.

Let's say he have 1 (B1) missing from 22 (C1).

I can do
=B1/C1 and it will return %4.55

But I want the answer to be %95.45

It must be easy, but I can't seem to calculate it!

Advice much appreciated.

Cheers

 

[SimonRigga]

I can do
=B1/C1 and it will return %4.55

=100 - (B1/C1)

 

[throwaway4372]

If you want 0.9545 it's this:
=1-(B3/C3)
which when formatted as % becomes 95.45%

If you want 95.45 it's this:
=100-((B1/C1)*100)