Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to make cell address reference increment?
hi, this shld be easiest one... i read thru the excel help file, but dun
really understand on which function to use... say i hv a formula =IF(A1=B1,C1+1,D1). in this case, the result will be value of C1 plus 1 if the logic is true. but my intention is actually to make increment on either the row or column to C1, which the expected result shld be equal to C2 (row) or D1 (column). which function shld i use for this? thanks in advance for help!! |
#2
|
|||
|
|||
Try use indirect function and address function!
=INDIRECT(ADDRESS(rowno,3)) You can dynamically change row number: rowno ===== * ===== * ===== * ===== Daniel CHEN Spreadsheet/VBA Specialist www.Geocities.com/UDQServices Your "Impossible" Task Could Be Someone Else's "Piece of Cake" ===== * ===== * ===== * ===== "jacko" wrote in message ... hi, this shld be easiest one... i read thru the excel help file, but dun really understand on which function to use... say i hv a formula =IF(A1=B1,C1+1,D1). in this case, the result will be value of C1 plus 1 if the logic is true. but my intention is actually to make increment on either the row or column to C1, which the expected result shld be equal to C2 (row) or D1 (column). which function shld i use for this? thanks in advance for help!! |
#3
|
|||
|
|||
=IF(A1=B1,ROW()+1,COLUMN()+1)
-- HTH Bob Phillips "jacko" wrote in message ... hi, this shld be easiest one... i read thru the excel help file, but dun really understand on which function to use... say i hv a formula =IF(A1=B1,C1+1,D1). in this case, the result will be value of C1 plus 1 if the logic is true. but my intention is actually to make increment on either the row or column to C1, which the expected result shld be equal to C2 (row) or D1 (column). which function shld i use for this? thanks in advance for help!! |
#4
|
|||
|
|||
Jacko,
=IF(A1=B1,C2,D1) But if you have some other incrementing scheme: =OFFSET(C1,(A1=B1)*1,(A1<B1)*1) =OFFSET(C1,(A1=B1)*2,(A1<B1)*2) =OFFSET(C1,(A1=B1)*(other formula),(A1<B1)*(other formula)) HTH, Bernie MS Excel MVP "jacko" wrote in message ... hi, this shld be easiest one... i read thru the excel help file, but dun really understand on which function to use... say i hv a formula =IF(A1=B1,C1+1,D1). in this case, the result will be value of C1 plus 1 if the logic is true. but my intention is actually to make increment on either the row or column to C1, which the expected result shld be equal to C2 (row) or D1 (column). which function shld i use for this? thanks in advance for help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
international absulute cell reference | Excel Discussion (Misc queries) |