K
KMC
If I have a dollar amount in one cell. I would like to have another cell that
always show 20% of that cell.
always show 20% of that cell.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
How about the simple formula =A1*20% ?
C
CLR
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
amount to show..........
=A1*.2
Vaya con Dios,
Chuck, CABGx3
D
Drregion
Where A1 is the cell the original dollar amount is in:
=A1*.2
format both cells for $
=A1*.2
format both cells for $
K
KMC
Thanks for the help!
CLR said: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