Thread: Using the value of a common cell as a multiple for many other cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EDH-Grill EDH-Grill is offline
external usenet poster
  
Posts: 1
Default Using the value of a common cell as a multiple for many other cell
how can I use the value of 1 cell as a calculation componet for multiple
cells. For example, I have a total revenue figure in cell B3 and I want to
know the % of that revenue figure that ~20 different expense lines represent.
I've done this before and I believe that there is a "$" inserted somewhere
in the formula
Reply With QuoteReply With Quote