Inverse Percentage in a cell

[jpkreider]

Hey All,

I just want a formula embedded in a cell that automatically inverses the percentage that I enter. I'm going to be inputting data from a source other than excel, but I want to show the opposite percentage. So say their data shows 25%, I want to manually enter that 25% into the spreadsheet, but I want it to show 75% in the cell that I enter 25% into. I hope that makes sense. Any help would be appreciated. Thanks!

 

[pvr928]

Hi jpkreider

Is this what you want?

Cell A1 (or the cell reference where you 'manually enter that 25%')
25%

Cell B1 (or wherever you wish to show the inverse of the percentage entered in the reference above)

=1-A1

(formatted '0%')

Cheers

pvr928

 

[jpkreider]

I just want to enter 25% into A1 and have a formula that will automatically change it to 75% in A1. Basically, without needing other cells to pull from. Possible?

Hi jpkreider

Is this what you want?

Cell A1 (or the cell reference where you 'manually enter that 25%')
25%

Cell B1 (or wherever you wish to show the inverse of the percentage entered in the reference above)

=1-A1

(formatted '0%')

Cheers

pvr928

 

[pvr928]

Hi jpkereider

No need to requote.

Place this in a Worksheet module:

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("A1") Then
    Application.EnableEvents = False
    Target.Value2 = Format(1 - Target.Value2, "0%")
    Application.EnableEvents = True
Else
End If
End Sub

Change the reference "A1" to whatever you want it to be.

Cheers

pvr928