+ Reply to Thread
Results 1 to 5 of 5

Created function return value 0 only

  1. #1
    Registered User
    Join Date
    09-04-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    27

    Created function return value 0 only

    Hi all,

    I had created a function based on the formula as attached but my function return value of 0 only. Please advise where I had gone wrong? Thanks.

    MultimodalFnc.jpg

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645
    Can you give some examples of the numbers you are passing to the function?
    If posting code please use code tags, see here.

  3. #3
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Created function return value 0 only

    Your function will take Pi to be a variable, equal to 0 as it is not defined. Therefore number*pi*0.05 will be equal to 0, sin(0) = 0, therefore x1 = x1*0 = 0 and MM = -2*0/x3 = 0. Try
    Please Login or Register  to view this content.
    Note, the power function doesn't work for me but that could be a version thing, I would use
    Please Login or Register  to view this content.
    instead

  4. #4
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Created function return value 0 only

    The function Power and the constant Pi do not exist in Excel

    try

    Please Login or Register  to view this content.
    If you like my contribution click the star icon!

  5. #5
    Registered User
    Join Date
    09-04-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    27

    Re: Created function return value 0 only

    Thanks...I need to define the Pi value. I had defined function of power.

    Please Login or Register  to view this content.

+ 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. Excel 2007 : cant find the vba function i've created
    By Nutshell in forum Excel General
    Replies: 4
    Last Post: 10-27-2010, 09:25 AM
  2. Return VBA Created Range
    By bondslaveofchrist in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-24-2008, 06:20 PM
  3. I Created Buckets Function
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2008, 11:24 AM
  4. VBA to return date created
    By Gtree in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2007, 09:12 AM
  5. Referring to function in another workbook:created a VB function
    By psp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-31-2005, 07:05 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