| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas that refer to a cell in the last row
I have the following two functions in the following cells on my worksheet.
AJ10 =IF(SUM(AB7:AG7)<0,(E47+SUM(AB7:AG7))/(C47+SUM(AB4:AG4)),"") AJ17 =IF(AB15<"",IF(AB14<"",(((AB15+C47)*AB14)-E47)/AB15,""),"") The first formula uses C47 and the second uses C47 and E47. These cells were the last row of my sheet when I made them. However this row changes and row 57 is now the last row. I need help setting up my formulas so they update accordingly. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas that refer to (several) other columns for arguments... | Excel Worksheet Functions | |||
| Formulas that refer to other colums for arguments? | Excel Worksheet Functions | |||
| How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
| How to refer to every 5 th cell? | Excel Discussion (Misc queries) | |||
| Excel should let me use formulas that refer to other cells w/ form | Excel Worksheet Functions | |||
Threaded Mode
