| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to 'Calculate' an Excel Reference
I'm trying to determine how I can easily change a cell reference in a formula
to a different value based on a calculation in my spreadsheet. For example: I have the formula Sum(A1:A10) In reality, I would like the formula to change depending on the value in another cell (say cell B1) so that when B1 = 54, the formula becomes Sum(A1:A54). Is there a way I can change the reference in the formula in this manner using cell values or constants? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to calculate integrals with Excel? | Excel Worksheet Functions | |||
| Does Excel use least squares regression to calculate trendlines? | Charts and Charting in Excel | |||
| Excel should have a absolute reference cell property. | Excel Discussion (Misc queries) | |||
| Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
| using a reference in vlookup with excel 2003 | Excel Worksheet Functions | |||
Threaded Mode
