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