Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula in dropdown list
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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()) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula connected to a dropdown list | Excel Discussion (Misc queries) | |||
dropdown list determined by another dropdown list | Excel Discussion (Misc queries) | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
How do I reference a formula to a dropdown list | Excel Discussion (Misc queries) |