Results 1 to 10 of 10

Formula sqrt to VBA conversion

Threaded View

  1. #1
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    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
    Option Explicit
    
    Sub Test()
    Dim CatSz As Long, Size As Long, Prop As Double, StdErr As Double
    Size = [F23]
    CatSz = [F24]
    Prop = CatSz / Size
    StdErr = Sqr((Prop * (1 - Prop) / Size))
    End Sub
    Attached Files Attached Files
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VB sqrt problem
    By Unipop in forum Excel General
    Replies: 4
    Last Post: 10-02-2016, 10:25 AM
  2. VB sqrt problem
    By Unipop in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-02-2016, 10:11 AM
  3. Problem with sqrt
    By Bartek120 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2016, 06:11 PM
  4. =+g12*2.20452+10.518+(2*sqrt(10.9)-2*sqrt(g13))
    By luisfsantos in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-13-2013, 08:21 AM
  5. Excel 2007 : SQRT problems
    By frdranger25401 in forum Excel General
    Replies: 1
    Last Post: 04-14-2011, 01:56 PM
  6. UDF using SQRT function
    By Vlad999 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2007, 09:14 PM
  7. how to multiply 29,5 with sqrt of 12
    By Smiley in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2005, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1