Passing a row to a function

[dch3]

I need to take the row value of the cell in which a function appears and pass
that value into the function itself. As in the example below, cells A1, A2,
A3 all contain the function getName(), I would like getName() to evaluate
differently based on the row number. Is this possible?

COLUMN
ROW A B
1 =getName()
2 =getName()
3 =getName()

[Barb Reinhardt]

row()?

"dch3" wrote:

> I need to take the row value of the cell in which a function appears and pass
> that value into the function itself. As in the example below, cells A1, A2,
> A3 all contain the function getName(), I would like getName() to evaluate
> differently based on the row number. Is this possible?
>
> COLUMN
> ROW A B
> 1 =getName()
> 2 =getName()
> 3 =getName()

[dch3]

That will work. In the future, you may want to elaborate a little bit more. I
didn't understand your response until I opened Excel and tried the function.
I obviously wasn't aware that it was a valid Excel function.

"Barb Reinhardt" wrote:

> row()?
>
> "dch3" wrote:
>
> > I need to take the row value of the cell in which a function appears and pass
> > that value into the function itself. As in the example below, cells A1, A2,
> > A3 all contain the function getName(), I would like getName() to evaluate
> > differently based on the row number. Is this possible?
> >
> > COLUMN
> > ROW A B
> > 1 =getName()
> > 2 =getName()
> > 3 =getName()