which is greater

[abhi.ashok]

hi all ,

i want to perform comparison between two variable and find out which is greater without using comparison operator.

give me suitable answer,

regards,

abhishek mishra

[gavio]

You can perform the substraction and compare the result with 0 (zero):

Dim A As Double, B As Double
    A = 0.1
    B = 0.2
        Select Case (A - B)
            Case 0
                Debug.Print "A equals B"
            Case Is < 0
                Debug.Print "B is grater then A"
            Case Else
                Debug.Print "A is grater then B"
        End Select

[Dnereb]

Althoug I think it's utter nonsense to do so:

Sub test3()

A = 50
B = 20
C = A - B

If (C = Abs(C)) Then MsgBox "A = larger"

End Sub

[ganeshmoorthy]

i want to perform comparison between two variable and find out which is greater without using comparison operator.

But why do you want to do so

[gavio]

But why do you want to do so

Isn't it obvious?

@abhi.ashok: i don't believe it's possible, but if it is, it may not be so easy as you may think.

[zynder]

What is your purpose of doing so? Why make your life difficult?

[Dnereb]

See my solution here:
Your Thread in the math forum

[Hack]

Duplicate threads merged.

Please do not double post the same question.

[zaza]

Alternatively to the above, test:

MyVal = sqr(1-mod(A/B))

If A > B, then mod(A/B) > 1 and so you attempt to sqrt a negative number, which will throw an error.
If B > A, then mod(A/B) < 1 and the sqrt succeeds.

Not as good a method as Dnereb's, because you specifically design an error into it, but an alternative nevertheless.

[superbovine]

hi all ,

i want to perform comparison between two variable and find out which is greater without using comparison operator.

give me suitable answer,

regards,

abhishek mishra

give me a suitable answer. I seemed to remember this as a homework quesiton from college which I am sure this is.

On a very low very you can do bitwise operation to compare the bits of the variable. Pretend you are designing a circuit for a comparison operator on a cpu.

ok, i am going to assume you know binary, how to add and subtract in binary, 2 compliment, and you know boolean math. If you don't know these you arent going to understand this nor will understand how a processor works.

anyway, just do binary subtraction for each bit of the 2 numbers using AND and Invert. if the resultant MSB is 1 then number is negative and first number was smaller, expect in the case of two negative numbers.

[triggernum5]

It could also be done with boolean operators.. Are you allowed to compare the numbers 1 bit at a time? Or are you forced to compare the entire value on a single line?
Boolean math can actually eliminate/transform virtually any IF statement..
Doh, how did I overlook the fact that what I am saying was just said by SuperBovine..