ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   equation for percentile of another cell (https://www.excelbanter.com/excel-discussion-misc-queries/61634-equation-percentile-another-cell.html)

KMC

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

Bernard Liengme

equation for percentile of another 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.




CLR

equation for percentile of another 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.


Drregion

equation for percentile of another 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.


KMC

equation for percentile of another 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.



All times are GMT +1. The time now is 04:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com