| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a cell reference into this formula...
Hi guys--
I have an Excel database with a 3-cell address field that I need to parse into other cells. Here is what I have so far: =IF((MOD(ROW(),3))=0, E(ROW()-2), " ") What I want to do is, every 3 rows (say I'm in row190) to put the contents of E187 in the current cell. The "mod" part is working OK, but how do you construct the "E187" cell reference? So far, no luck. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get a cell reference into this formula...
Try using INDIRECT, such as:
=IF((MOD(ROW(),3))=0, INDIRECT("E"&(ROW()-2)), " ") Hope this helps. Pete PhillyRon wrote: Hi guys-- I have an Excel database with a 3-cell address field that I need to parse into other cells. Here is what I have so far: =IF((MOD(ROW(),3))=0, E(ROW()-2), " ") What I want to do is, every 3 rows (say I'm in row190) to put the contents of E187 in the current cell. The "mod" part is working OK, but how do you construct the "E187" cell reference? So far, no luck. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get a cell reference into this formula...
TRY:
=IF((MOD(ROW(),3))=0,INDIRECT("E"&ROW()-2)," ") HTH "PhillyRon" wrote: Hi guys-- I have an Excel database with a 3-cell address field that I need to parse into other cells. Here is what I have so far: =IF((MOD(ROW(),3))=0, E(ROW()-2), " ") What I want to do is, every 3 rows (say I'm in row190) to put the contents of E187 in the current cell. The "mod" part is working OK, but how do you construct the "E187" cell reference? So far, no luck. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get a cell reference into this formula...
Thanks, HTH; that's the ticket.
PhillyRon "Toppers" wrote: TRY: =IF((MOD(ROW(),3))=0,INDIRECT("E"&ROW()-2)," ") HTH "PhillyRon" wrote: Hi guys-- I have an Excel database with a 3-cell address field that I need to parse into other cells. Here is what I have so far: =IF((MOD(ROW(),3))=0, E(ROW()-2), " ") What I want to do is, every 3 rows (say I'm in row190) to put the contents of E187 in the current cell. The "mod" part is working OK, but how do you construct the "E187" cell reference? So far, no luck. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function/ formula to output a cell reference | Excel Worksheet Functions | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
| Reference to One Cell stays the same in Different Formula | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
