| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
simple equation
i know that ROW() gives me the current row, but lets say i want to select the cell at column B on the current ROW and devide that by the cell at column D on the current ROW. how would i select these specific cells? -- true_atlantis ------------------------------------------------------------------------ true_atlantis's Profile: http://www.excelforum.com/member.php...o&userid=32957 View this thread: http://www.excelforum.com/showthread...hreadid=527898 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
simple equation
One way:
=INDEX(B:B,ROW())/INDEX(D:D,ROW()) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "true_atlantis" wrote in message news:true_atlantis.25gl7y_1143682200.8669@excelfor um-nospam.com... i know that ROW() gives me the current row, but lets say i want to select the cell at column B on the current ROW and devide that by the cell at column D on the current ROW. how would i select these specific cells? -- true_atlantis ------------------------------------------------------------------------ true_atlantis's Profile: http://www.excelforum.com/member.php...o&userid=32957 View this thread: http://www.excelforum.com/showthread...hreadid=527898 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
simple equation
The normal way woud be, if ROW is #8, =B8/D8 That is. divided B8 by
D8. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
simple equation
The normal way woud be, if ROW is #8, =B8/D8 That is. divided B8 by
D8. ed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Equation to refer to data value(s) and not the cell?? | Excel Discussion (Misc queries) | |||
| simple math equation | Excel Discussion (Misc queries) | |||
| Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
| Need Help with #N/A in equation | Excel Discussion (Misc queries) | |||
| need help with a simple xls equation !! | Excel Worksheet Functions | |||
Hybrid Mode
