+ Reply to Thread
Results 1 to 4 of 4

Vba function problem

  1. #1
    Registered User
    Join Date
    06-10-2021
    Location
    krakow, poland
    MS-Off Ver
    365
    Posts
    2

    Question Vba function problem

    I don't know what i did wrong but when I'm trying to use those two Functions they are not running.

    Here is my exercise :

    2.JPG


    And here is my function:

    1PNG.JPG
    Last edited by zaneta0709; 06-16-2021 at 06:25 AM.

  2. #2
    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: Vba function problem

    Using standard Excel

    Antoine: With A1 = 8.0897, B1 = 1582.271, C1 = 239.726 D1 = 50
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    which gives 425.04, different to your 416.6

    Option B

    A1 = 200, B1 = 0.5, C1 = 4
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    = 27.0676

    As UDF's

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    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.

  3. #3
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,257

    Re: Vba function problem

    Also posted here: https://www.mrexcel.com/board/thread...oblem.1173426/
    Remember what the dormouse said
    Feed your head

  4. #4
    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: Vba function problem

    Thanks Rory

    @Zaneta


    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Problem with indirect function in XIRR function
    By lynnsong986 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-17-2020, 05:12 PM
  2. Function problem: Function correct but not running
    By helterskelter101 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-04-2018, 10:17 AM
  3. [VBA] Problem with outmail function - function sends mails only to 1 recepient
    By sauron12 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2015, 03:30 PM
  4. Replies: 6
    Last Post: 10-20-2013, 07:16 PM
  5. Problem Inserting Round function into an IF function
    By Ash87 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2013, 05:37 PM
  6. Problem with the 'IF' function
    By bobmcbob in forum Excel General
    Replies: 2
    Last Post: 12-12-2011, 10:39 PM
  7. IF function problem
    By bannister47 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-01-2011, 11:24 AM

Tags for this Thread

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