Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
I am trying to set up a formula that will return the data in the last cell in
a row. The problem I am having is that the row grows daily. Therefore, if the Cell I want the data to populate in is I3, then my row goes from J3 to infinity or at least Z3 as I add to it. Therefore, I3 should return whatever cell is the last cell in the row with data in it. I have tried an IF statement but it is very long and it only allows me to input upto 8 statements or upto only R3. Any suggestions? Here is the statement that I am using: =IF(R3=0,(IF(Q3=0,(IF(P3=0,(IF(O3=0,(IF(N3=0,(IF(M 3=0,(IF(L3=0,(IF(K3=0,J3,K3)),L3)),M3)),N3)),O3)), P3)),Q3)),R3) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) |