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