Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Continue formula until reaching a blank cell.
I have 3 formulas that need to be repeated in column U (dependant on the cost
type) as long as there is information in column E. One of the formulas I have in Column U is: =IF(V" & RowCount & "<AA" & RowCount & _ ",AA" & RowCount & "*AG" & RowCount & ",MAX(K" & RowCount & _ ",N" & RowCount & ",AA" & RowCount & "*AG" & RowCount & "))". Would I need to put another =IF in front of this code to have it proceed and run this formula until it encounters a blank cell in column E? It's my last little bit on this MONSTER! Help anyone ?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to return a blank formula cell if the reference is blank? | Excel Worksheet Functions | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
leave cell blank and continue with formula | Excel Worksheet Functions | |||
If blank cell continue macro | Excel Programming | |||
Formula that will leave cell blank if cell is blank | Excel Programming |