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.

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

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.