Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jacko
 
Posts: n/a
Default 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   Report Post  
Daniel CHEN
 
Posts: n/a
Default

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   Report Post  
Bob Phillips
 
Posts: n/a
Default

=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   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
reference cell value from fixed column with variable row bob z Excel Discussion (Misc queries) 0 May 23rd 05 11:30 PM
how do I make a word typed in a cell go to a specific cell in anot Lmatarazzo Excel Discussion (Misc queries) 3 April 21st 05 04:29 AM
Cell Formula reference to cell Based On third Cell Content Gabriel Excel Discussion (Misc queries) 0 February 11th 05 06:35 AM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 02:01 PM
international absulute cell reference Sadinga Excel Discussion (Misc queries) 5 December 22nd 04 11:08 PM


All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"