formula-percrntage

[bjw432]

i am trying to figure out how to put a formula in that will be able to get a
percentage of a number in one cell with the answer in another cell without
showing the percent rate that was used to get the answer. Any help would be
appreciated. Thanks

 

[Gord Dibben]

Defining a name for the percentage is one method.

Select any cell and Insert>Name>Define>Name qwerty

Refers to 13% and OK

In a cell enter =A1*qwerty

Users can always snoop in to find the name if they choose.

And remember.........if users can see the original number they can always
reverse-engineer from the formula results.

In short, you are hooped.


Gord Dibben MS Excel MVP