Calculating Row Number for a Formula

[alexis]

Hi,

I'd like to have a column in my worksheet that calculates
a row number that I then use in a formula. For example,
in this formula:

=IF(ISBLANK(B2), "", "Hello")

I would want to use a worksheet cell to specify the "2"
in the cell specification "B2", but I don't know how to
do this, or if it's supported. Maybe something like this?

=IF(ISBLANK(B[A1]), "", "Hello")

where A1 contains the row number I want to use.

Thanks in advance for help!
alexis

 

[JulieD]

Hi Alexis

try
=IF(ISBLANK(INDIRECT(A1)),"","Hello")

Cheers
JulieD

 

[alexis]

Thanks, that's exactly what I needed!

-----Original Message-----
Hi Alexis

try
=IF(ISBLANK(INDIRECT(A1)),"","Hello")

Cheers
JulieD

Hi,

I'd like to have a column in my worksheet that calculates
a row number that I then use in a formula. For example,
in this formula:

=IF(ISBLANK(B2), "", "Hello")

I would want to use a worksheet cell to specify the "2"
in the cell specification "B2", but I don't know how to
do this, or if it's supported. Maybe something like this?

=IF(ISBLANK(B[A1]), "", "Hello")

where A1 contains the row number I want to use.

Thanks in advance for help!
alexis

.

 

[JulieD]

glad to help

Thanks, that's exactly what I needed!

-----Original Message-----
Hi Alexis

try
=IF(ISBLANK(INDIRECT(A1)),"","Hello")

Cheers
JulieD

Hi,

I'd like to have a column in my worksheet that calculates
a row number that I then use in a formula. For example,
in this formula:

=IF(ISBLANK(B2), "", "Hello")

I would want to use a worksheet cell to specify the "2"
in the cell specification "B2", but I don't know how to
do this, or if it's supported. Maybe something like this?

=IF(ISBLANK(B[A1]), "", "Hello")

where A1 contains the row number I want to use.

Thanks in advance for help!
alexis

.