G
Guest
Hi, I'm trying to use the contents of a cell (as opposed to the actual cell)
in a Formula. For example – in the following Statement:
=AVERAGE(IF((PRICES!D$32848$34120=A44),PRICES!P$32848$34120))
Instead of using ‘PRICES!D$32848$34120’, I want to use the contents of
another cell – lets say Cell A2’
Cell A2 would contain the character expression ‘PRICES!D$32848$34120’
So the statement above would read something like:
=AVERAGE(IF((? A2 ?),PRICES!P$32848$34120))
How do I get the statement above to recognize the contents of cell A2
instead of cell A2?
I know I could create a label range but what I am trying to do will work
much better if I can refer to the contents of a given cell.
I seem to remember being able to do this long ago in Lotus.
Thanks,
in a Formula. For example – in the following Statement:
=AVERAGE(IF((PRICES!D$32848$34120=A44),PRICES!P$32848$34120))
Instead of using ‘PRICES!D$32848$34120’, I want to use the contents of
another cell – lets say Cell A2’
Cell A2 would contain the character expression ‘PRICES!D$32848$34120’
So the statement above would read something like:
=AVERAGE(IF((? A2 ?),PRICES!P$32848$34120))
How do I get the statement above to recognize the contents of cell A2
instead of cell A2?
I know I could create a label range but what I am trying to do will work
much better if I can refer to the contents of a given cell.
I seem to remember being able to do this long ago in Lotus.
Thanks,