Formula in dropdown list
 

I am using Data Validation / dropdown to allow a user to select either a
static entry or a calculated one.
There is a line of products a1=apple b1=banana c1=cucumber
There is a line of prices a2=35 b2=25 c2=38
There is a 'select price' row.
The user can select from 49, 59, or 'the row above *1.5'
I can create the indirect command =indirect("R[-1]C",0)*1.5 and that works
fine
BUT - I can't get it from the validation list.
The list will only present the VALUE that cell in the validation list
computed - not the formula itself.
I've tried a couple of ways - including using a vlookup, but the problem is
the same. Any suggestions?

Formula in dropdown list
 

On Thu, 4 Feb 2010 16:41:01 -0800, David Pickering <David
wrote:

I am using Data Validation / dropdown to allow a user to select either a
static entry or a calculated one.
There is a line of products a1=apple b1=banana c1=cucumber
There is a line of prices a2=35 b2=25 c2=38
There is a 'select price' row.
The user can select from 49, 59, or 'the row above *1.5'
I can create the indirect command =indirect("R[-1]C",0)*1.5 and that works
fine
BUT - I can't get it from the validation list.
The list will only present the VALUE that cell in the validation list
computed - not the formula itself.
I've tried a couple of ways - including using a vlookup, but the problem is
the same. Any suggestions?


=TEXT(yourformulahere())

Formula in dropdown list
 

Thank you for the prompt reply - but I have tried exactly that (and a bunch
of other things) and it didn't work. That places the formula into the a3 (or
b3 or c3) cell - but as TEXT. It's not active. It's just
'=indirect(etc...). I need something at will let me copy a FORMULA from a
dropdown, not its result - and not its text image.

"CellShocked" wrote:

On Thu, 4 Feb 2010 16:41:01 -0800, David Pickering <David
wrote:
My problem seen above

=TEXT(yourformulahere())