Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using the value of a common cell as a multiple for many other cell
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 "EDH-Grill" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print excel spreadsheet splitting cell contents on multiple pages | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
a unique cell value returns multiple cell values from another shee | Excel Worksheet Functions | |||
Counting Multiple Values In A Cell | Excel Worksheet Functions |