+ Reply to Thread
Results 1 to 2 of 2

Summation in VBA

Hybrid View

  1. 03-13-2012, 12:32 PM #1
    spenserb
    spenserb is offline
    Registered User
    Join Date
    03-13-2012
    Location
    Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    1

    Summation in VBA

    Never used VBA before, but I want to write a simple code to calculate the following equation, anyone know how to do this the most efficently?

    "i" will always be 1, but I want to be able to manipulate the 3 variables n,TFi and Q (TFi is one variable in itself)

    The JPG of the equation is attached, let me know if it doesn't work for some reason...
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 03-13-2012, 01:21 PM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Summation in VBA

    Hi,

    You don't need VBA.

    With n in A1, TFi in A2 and Q in A3 use

    =(A1+1)/2*A1*A2*A3
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1