If I have a dollar amount in one cell. I would like to have another cell that
always show 20% of that cell.

How about the simple formula =A1*20% ?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"KMC" wrote in message
...
If I have a dollar amount in one cell. I would like to have another cell
that
always show 20% of that cell.

If your dollar amount is in cell A1, put this formula where you want the 20%
amount to show..........

=A1*.2

Vaya con Dios,
Chuck, CABGx3



"KMC" wrote:

If I have a dollar amount in one cell. I would like to have another cell that
always show 20% of that cell.

Where A1 is the cell the original dollar amount is in:
=A1*.2
format both cells for $

"KMC" wrote:

If I have a dollar amount in one cell. I would like to have another cell that
always show 20% of that cell.

Thanks for the help!

"CLR" wrote:

If your dollar amount is in cell A1, put this formula where you want the 20%
amount to show..........

=A1*.2

Vaya con Dios,
Chuck, CABGx3



"KMC" wrote:

If I have a dollar amount in one cell. I would like to have another cell that
always show 20% of that cell.