Need cell value not cell pointer returned from formula

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.
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top