# Remaining percentage

#### Martyinco

##### New Member
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

### Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

#### elviajero

##### Board Regular
=IF(A1=0,0,1-A1)

That should do it.

#### SpillerBD

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

#### Martyinco

##### New Member
elviajero and SpillerBD your are both awesome, thank you

Replies
1
Views
55
Replies
0
Views
107
Replies
9
Views
149
Replies
12
Views
169
Replies
2
Views
125

1,195,628
Messages
6,010,771
Members
441,568
Latest member
abbyabby

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back