Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate a Logical Test
I want to combine cells into a logical test. I can't explain what I want, so
here is an example. Example 1: Input A1: 1 A2: < A3: 2 A4: ???Formula??? Result A4: True |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate a Logical Test
How about in A1 thru A4
= 1 < 2 then anywhere =QWERTY() will give you TRUE: Function qwerty() Dim s As String s = Cells(1, 1) & Cells(2, 1) & Cells(3, 1) & Cells(4, 1) qwerty = evaluate(s) End Function -- Gary's Student "Sloth" wrote: I want to combine cells into a logical test. I can't explain what I want, so here is an example. Example 1: Input A1: 1 A2: < A3: 2 A4: ???Formula??? Result A4: True |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate a Logical Test
That worked! Thank You
I have just one question. I inserted this function as a new module. When I change the values the cell with the QWERTY function does not update untill I hit F2 and press enter. It won't update even when I hit the calculate button. With multiple cells I have to update each cell individually each time. What's going on? "Gary''s Student" wrote: How about in A1 thru A4 = 1 < 2 then anywhere =QWERTY() will give you TRUE: Function qwerty() Dim s As String s = Cells(1, 1) & Cells(2, 1) & Cells(3, 1) & Cells(4, 1) qwerty = evaluate(s) End Function -- Gary's Student "Sloth" wrote: I want to combine cells into a logical test. I can't explain what I want, so here is an example. Example 1: Input A1: 1 A2: < A3: 2 A4: ???Formula??? Result A4: True |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate a Logical Test
I apologize. As coded Cntrl-Alt-F9 show kick it awake or include:
Application.Volatile True in the function Play around with it. It is interesting that functions can be made by splicing text strings. -- Gary's Student "Sloth" wrote: That worked! Thank You I have just one question. I inserted this function as a new module. When I change the values the cell with the QWERTY function does not update untill I hit F2 and press enter. It won't update even when I hit the calculate button. With multiple cells I have to update each cell individually each time. What's going on? "Gary''s Student" wrote: How about in A1 thru A4 = 1 < 2 then anywhere =QWERTY() will give you TRUE: Function qwerty() Dim s As String s = Cells(1, 1) & Cells(2, 1) & Cells(3, 1) & Cells(4, 1) qwerty = evaluate(s) End Function -- Gary's Student "Sloth" wrote: I want to combine cells into a logical test. I can't explain what I want, so here is an example. Example 1: Input A1: 1 A2: < A3: 2 A4: ???Formula??? Result A4: True |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate a Logical Test
Another note:
The reason that the function, as coded doesn't respond to changes is that A1 thru A4 aren't function arguments. Excel doesn't know that it needs to recalculate the darned thing when you change these values. -- Gary's Student "Gary''s Student" wrote: I apologize. As coded Cntrl-Alt-F9 show kick it awake or include: Application.Volatile True in the function Play around with it. It is interesting that functions can be made by splicing text strings. -- Gary's Student "Sloth" wrote: That worked! Thank You I have just one question. I inserted this function as a new module. When I change the values the cell with the QWERTY function does not update untill I hit F2 and press enter. It won't update even when I hit the calculate button. With multiple cells I have to update each cell individually each time. What's going on? "Gary''s Student" wrote: How about in A1 thru A4 = 1 < 2 then anywhere =QWERTY() will give you TRUE: Function qwerty() Dim s As String s = Cells(1, 1) & Cells(2, 1) & Cells(3, 1) & Cells(4, 1) qwerty = evaluate(s) End Function -- Gary's Student "Sloth" wrote: I want to combine cells into a logical test. I can't explain what I want, so here is an example. Example 1: Input A1: 1 A2: < A3: 2 A4: ???Formula??? Result A4: True |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate a Logical Test
Thanks again. If you are still reading this, what is the difference from F9
and ctrl+alt+F9? "Gary''s Student" wrote: Another note: The reason that the function, as coded doesn't respond to changes is that A1 thru A4 aren't function arguments. Excel doesn't know that it needs to recalculate the darned thing when you change these values. -- Gary's Student "Gary''s Student" wrote: I apologize. As coded Cntrl-Alt-F9 show kick it awake or include: Application.Volatile True in the function Play around with it. It is interesting that functions can be made by splicing text strings. -- Gary's Student "Sloth" wrote: That worked! Thank You I have just one question. I inserted this function as a new module. When I change the values the cell with the QWERTY function does not update untill I hit F2 and press enter. It won't update even when I hit the calculate button. With multiple cells I have to update each cell individually each time. What's going on? "Gary''s Student" wrote: How about in A1 thru A4 = 1 < 2 then anywhere =QWERTY() will give you TRUE: Function qwerty() Dim s As String s = Cells(1, 1) & Cells(2, 1) & Cells(3, 1) & Cells(4, 1) qwerty = evaluate(s) End Function -- Gary's Student "Sloth" wrote: I want to combine cells into a logical test. I can't explain what I want, so here is an example. Example 1: Input A1: 1 A2: < A3: 2 A4: ???Formula??? Result A4: True |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate a Logical Test
Its much more forcefull.
Its much better to fix the function to have arguments and then you won't need F9. -- Gary''s Student "Sloth" wrote: Thanks again. If you are still reading this, what is the difference from F9 and ctrl+alt+F9? "Gary''s Student" wrote: Another note: The reason that the function, as coded doesn't respond to changes is that A1 thru A4 aren't function arguments. Excel doesn't know that it needs to recalculate the darned thing when you change these values. -- Gary's Student "Gary''s Student" wrote: I apologize. As coded Cntrl-Alt-F9 show kick it awake or include: Application.Volatile True in the function Play around with it. It is interesting that functions can be made by splicing text strings. -- Gary's Student "Sloth" wrote: That worked! Thank You I have just one question. I inserted this function as a new module. When I change the values the cell with the QWERTY function does not update untill I hit F2 and press enter. It won't update even when I hit the calculate button. With multiple cells I have to update each cell individually each time. What's going on? "Gary''s Student" wrote: How about in A1 thru A4 = 1 < 2 then anywhere =QWERTY() will give you TRUE: Function qwerty() Dim s As String s = Cells(1, 1) & Cells(2, 1) & Cells(3, 1) & Cells(4, 1) qwerty = evaluate(s) End Function -- Gary's Student "Sloth" wrote: I want to combine cells into a logical test. I can't explain what I want, so here is an example. Example 1: Input A1: 1 A2: < A3: 2 A4: ???Formula??? Result A4: True |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a logical test for a cell's format instead of contents | Excel Worksheet Functions | |||
How do I use Roundup in a logical test in excel | Excel Worksheet Functions | |||
=IF logical test to search only part of a cell | Excel Worksheet Functions | |||
Logical test | Excel Discussion (Misc queries) | |||
logical test - within a range | Excel Worksheet Functions |