[RESOLVED] Excel 2007: returning the value of the next cell

[Art W.]

Hello Everyone:

I would like to know how to return the value of the next cell. I am using the following formula.

=Julian!B2

I want to use something like.

=Julian!B2+1

To return the value in cell C3 in the Julian worksheet. Now the value in B3 is 9 and C3 has a value of 8. If I use the above formula I get the values of 9 and 10.

I would also like to know how to return the value of “” if the cell is blank, I have done that but cannot remember how I did it?

I am using Excel 2007

Thanks
Art

[si_the_geek]

To get the value of a different cell like that, use the Offset function, eg:

=OFFSET(Julian!B2, 0, 1)

If you need to ensure that blank is displayed as blank (even if you have set the cell format to Number), use the If function, eg:

=If(OFFSET(Julian!B2, 0, 1)="","",OFFSET(Julian!B2, 0, 1))

[Art W.]

Hey Si The Geek:

The last line is exactly what I was looking for

Thanks for the excellent work.

Art