| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need cell value not cell pointer returned from formula
In the following formula, I want the cell value for the expression "H" &F5+1
not the cell pointer returned when G3-H3 is 0" If((G3-H3)=0,"H" &F5+1,(G3-H3) My formula specification when (G3-H3) = 0 returns H356. What I want is the value in H356 (column H, row 356) F5 contains the relative row number in an array. Is there some way to specify this so that I get the contents of the cell rather than a pointer to the cell? Thanks for your help on this. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need cell value not cell pointer returned from formula
Try:
=if(g3=h3,indirect("H"&f5+1),g3-h3) Cinco wrote: In the following formula, I want the cell value for the expression "H" &F5+1 not the cell pointer returned when G3-H3 is 0" If((G3-H3)=0,"H" &F5+1,(G3-H3) My formula specification when (G3-H3) = 0 returns H356. What I want is the value in H356 (column H, row 356) F5 contains the relative row number in an array. Is there some way to specify this so that I get the contents of the cell rather than a pointer to the cell? Thanks for your help on this. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need cell value not cell pointer returned from formula
=IF((G3-H3)=0,INDIRECT("H"&F5+1),(G3-H3))
-- Regards, OssieMac "Cinco" wrote: In the following formula, I want the cell value for the expression "H" &F5+1 not the cell pointer returned when G3-H3 is 0" If((G3-H3)=0,"H" &F5+1,(G3-H3) My formula specification when (G3-H3) = 0 returns H356. What I want is the value in H356 (column H, row 356) F5 contains the relative row number in an array. Is there some way to specify this so that I get the contents of the cell rather than a pointer to the cell? Thanks for your help on this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell pointer position | Excel Discussion (Misc queries) | |||
| Pointer and Cell | Excel Discussion (Misc queries) | |||
| Cell pointer | Excel Discussion (Misc queries) | |||
| Find cell which returned maximum value in formula | New Users to Excel | |||
| How do i add cell values that are returned via a formula | Excel Discussion (Misc queries) | |||
Linear Mode
