Need cell value not cell pointer returned from formula

  • Thread starter Thread starter Cinco
  • Start date Start date
C

Cinco

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.
 
Try:
=if(g3=h3,indirect("H"&f5+1),g3-h3)


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.
Click to expand...
 
Back
Top