View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Drregion
 
Posts: n/a
Default 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.