Remaining percentage

[Martyinco]

I am trying to figure out a formula to read the remaining percentage of a cell. Example:

Cell A1 is 90% I want Cell A2 to read 10%, but if A1 is 0% than A2 still reads 0%

Does that make sense?

Thank you in advance for anyone who can steer me in the right direction

 

[elviajero]

=IF(A1=0,0,1-A1)

That should do it.

 

[SpillerBD]

so you want the conditional calculation
=if(A1=0,0,1-a1)

 

[Martyinco]

elviajero and SpillerBD your are both awesome, thank you