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

Defining a name for the percentage is one method.

Select any cell and InsertNameDefineName 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

On Tue, 8 Jul 2008 22:12:02 -0700, bjw432
wrote:

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