Pythagorean Theorem

[ISY]

Hello

How do you write the following formula in VBA?

=RADQ(A3^2+B3^2)

 

[shg]

One way:

myVariable = Evaluate("sqrt(A3^2 + B3^2)")

 

[ISY]

Hello

Already tried with

 

[Rick Rothstein]

Assuming A3 and B3 are cell references, then give this a try...

Hypotenuse = Sqr(Range("A3").Value * Range("A3").Value + Range("B3").Value * Range("B3").Value)

 

[Scott Huish]

ISY:
What is RADQ?

shg: Why not use VBA functions?

MsgBox Sqr(Range("A3") ^ 2 + Range("B3") ^ 2)

 

[ISY]

Hello

Thank you all,
I could not convert the Italian formula in VBA do I use the hundreds at each cycle here is the reason why the first test I had done with the formulas.

 

[Scott Huish]

MsgBox (Range("A3") ^ 2 + Range("B3") ^ 2) ^ (1 / 2)