Using the value of a common cell as a multiple for many other cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi,

You're quite correct, the dollar sign is use to make part or all the cell
reference absolute (non changing).

$B$3 will make the cell absolute
B$3 will make the row absolute
$B3 will make the column absolute

another way is to name your cell "B3" in this case, the name box is located
left of the formula bar (white input box), just select the cell and name it
what you want then you can use that name in your formula:

=A1*tax or =A1*price

HTH
Jean-Guy
 
Back
Top