| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change operator from cell value
Hi, i am trying to change to operator of a formula based on the value
of a cell. For example: A1 = 3 A2 = < A3 = 10 Formula: IF(A1&A2&A3,"yes","no") The i want to be able to Chande the operator ion A2. I have tried the formula above and it does not work. Any help would be great. THanks in advance for your help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change operator from cell value
InsertNameDefine nameProvide a name, say formulaA123, enter
=EVALUATE(A1&A2&A3) as reference, enter =formulaA123 in result cell! Regards, Stefi €˛Gareth.Evans€¯ ezt Ć*rta: Hi, i am trying to change to operator of a formula based on the value of a cell. For example: A1 = 3 A2 = < A3 = 10 Formula: IF(A1&A2&A3,"yes","no") The i want to be able to Chande the operator ion A2. I have tried the formula above and it does not work. Any help would be great. THanks in advance for your help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change operator from cell value
or rather
=IF(EVALUATE(A1&A2&A3),"yes","no") Stefi €˛Stefi€¯ ezt Ć*rta: InsertNameDefine nameProvide a name, say formulaA123, enter =EVALUATE(A1&A2&A3) as reference, enter =formulaA123 in result cell! Regards, Stefi €˛Gareth.Evans€¯ ezt Ć*rta: Hi, i am trying to change to operator of a formula based on the value of a cell. For example: A1 = 3 A2 = < A3 = 10 Formula: IF(A1&A2&A3,"yes","no") The i want to be able to Chande the operator ion A2. I have tried the formula above and it does not work. Any help would be great. THanks in advance for your help |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change operator from cell value
Hi thanks for the reply,
I cant seem to get the EVALUATE function to work, i get error "invalid function" |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change operator from cell value
What Excel version do you use? I tried it in Excel2003.
Make sure that you entered =IF(EVALUATE(A1&A2&A3),"yes","no") in name defining dialog reference field! EVALUATE does NOT work as a normal worksheet function! Stefi €˛Gareth.Evans€¯ ezt Ć*rta: Hi thanks for the reply, I cant seem to get the EVALUATE function to work, i get error "invalid function" |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change operator from cell value
Gareth.Evans wrote:
Hi thanks for the reply, I cant seem to get the EVALUATE function to work, i get error "invalid function" Look here for a further explanation: http://www.ozgrid.com/News/excel-eva....htm#ExcelTips |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Boolean / Logical Operator using Input Cell | Excel Worksheet Functions | |||
| Reference an Operator from a cell with Sumproduct | Excel Worksheet Functions | |||
| Can I absolute cell an operator: and/or | Excel Discussion (Misc queries) | |||
| How to use a cell value as operator in a worksheet reference? | Excel Worksheet Functions | |||
| add one cell with no equals operator | Excel Discussion (Misc queries) | |||
Linear Mode
