View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tugger Tugger is offline
external usenet poster
 
Posts: 8
Default Referencing same cell in calculation

Right on Chris! Man this is great stuff!

"Chris Rogers" wrote:

you may want to name your cells. you could name the one row as Amount
and name the cell that has the 11% sur-charge as Tax
(Insert/Name/Define). That way the reference won't change when you
copy it, and if you look at the formula it will make some sense instead
of f3*$A$1, you would see Amount * Tax