Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling operators in formulas
Posting here since this group is much more active than the regular excel board.
Is it possible to call the 'operator' value of a cell as opposed to the 'text' value? Example- A1 contains '' A2 contains 2 A3 contains 1 I want to test =A2A3 Using the formula =A2&A1&A3 gives '21 instead of True. Is there some other way to do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling operators in formulas
Hi,
Am Fri, 21 Jul 2017 21:41:46 -0700 (PDT) schrieb Matthew Dyer: Example- A1 contains '' A2 contains 2 A3 contains 1 I want to test =A2A3 Using the formula =A2&A1&A3 gives '21 instead of True. Is there some other way to do this? in B1 write: =A2&A1&A3 Then select C1 and define the name "Result" refers to: =EVALUATE(Sheet1!$B$1) Now write in C1: =Result Regards Claus B. -- Windows10 Office 2016 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling operators in formulas
So I can define a name that encapsulates the 'formula' I want to evaluate, then use the evaluate formula to do the evaluation, but I cannot directly use 'greater than' instead of the text ''. I like the workaround
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling operators in formulas
"Matthew Dyer" wrote in message So I can define a name that encapsulates the 'formula' I want to evaluate, then use the evaluate formula to do the evaluation, but I cannot directly use 'greater than' instead of the text ''. I like the workaround Yes EVALUATE is also Macro4 function which you can use in a named formula, eg =EVALUATE(Sheet1!$A$2&Sheet1!$A$1&Sheet1!$A$3) Note where the cursor is when defining, depending on usage you may or may not want the $'s in the named formula. If all you want to do is cater for the 4 comparison operators =IF(A1="",A2A3,IF(A1="=",A2=A3,IF(A1="<",A2<A3 ,IF(A1="<=",A2<=A3)))) With an additional IF could include "=" Easily adapted for 'greater than' Could also be defined as a named formula Peter T |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling operators in formulas
"Peter T" wrote in message Yes EVALUATE is also Macro4 function which you can use in a named formula, Sorry, I misread Claus had already used Evalueate as a named formula PT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparison Operators in formulas | Excel Discussion (Misc queries) | |||
Using Or and And Operators | Excel Programming | |||
Operators/if etc | Excel Programming | |||
Comparison Operators | Excel Programming | |||
Unary operators | Excel Worksheet Functions |