software

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

quot;KMCquot; gt; wrote in message
...
gt; If I have a dollar amount in one cell. I would like to have another cell
gt; that
gt; 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
quot;KMCquot; wrote:

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

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

quot;KMCquot; wrote:

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

Thanks for the help!

quot;CLRquot; wrote:

gt; If your dollar amount is in cell A1, put this formula where you want the 20%
gt; amount to show..........
gt;
gt; =A1*.2
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;KMCquot; wrote:
gt;
gt; gt; If I have a dollar amount in one cell. I would like to have another cell that
gt; gt; always show 20% of that cell.