View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Crowther
 
Posts: n/a
Default 'of' percentage with calculation (attempt 2)

Hi,

I'm not very good with math...
(and not too hot with English either, based on pervious post)

I'm trying to achieve a cell that divides a cell number by 2 and then shows
20% €˜off the result (minus 20%).

e.g. this - 564.29 €“ to this - 225.72

I can do it in 2 cells using lots of brackets but cant figure the calc out
in one cell.

Thanks