Formula sqrt to VBA conversion

Hi Guys

In attached sample file I am trying to get F26 calculation...
The code does not error but the answer is an error...Any ideas

Please Login or Register  to view this content.

Hi kasan

This is my result ... Office 2007, 2013
Untitled.png

I broke the calc down into parts (adding the following)

Please Login or Register  to view this content.

I Dimmed a,b and c as Double's

The problem seems to occur in (b), it correctly calculates a = 0.35 but then gets 0.35 / 60 as being 5.833333333E-03

? strange

Originally Posted by sintek

Hi kasan

This is my result ... Office 2007, 2013
Attachment 588614

I also get the incorrect answer

What makes you say it's an error output?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

That's not an error, just a small number.

Hallo Trevor

Tx for putting me out of my misery lol...Please elaborate ...

just a small number.

Edit... Now I get it ...Only noticed that all the calculations to follow after running Main code calculates as it should ...

Small Magnitudes

For numbers with the smallest possible magnitude (closest to 0), Double variables can hold numbers as small as -4.94065645841246544E-324 for negative values and 4.94065645841246544E-324 for positive values.

@ kasan...

Your code gave me the same result as manual calculations with formulas.

How did you achieve that ...

Well, to be exact, it's a small(ish) number with a lot of digits after the decimal point ... 6.15765106730372E-02.

Excel is limited to the number of digits it can display/handle.

If you round the result to, say, 15 digits after the decimal point, you get 0.061576510673037. That is,around six one hundredths (and a little bit)

In the code above, I rounded the result to 10 digits. It rather depends on what level of accuracy you need.

You're welcome. Thanks for the rep.