Calculating Row Number for a Formula

  • Thread starter Thread starter alexis
  • Start date Start date
A

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
 
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
Click to expand...


.
Click to expand...
 
glad to help

alexis said:
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
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top