+ Reply to Thread
Results 1 to 5 of 5

Wrong Result Come out on TextBox

  1. #1
    Registered User
    Join Date
    03-08-2016
    Location
    Malaysia
    MS-Off Ver
    MS Office 2010
    Posts
    5

    Wrong Result Come out on TextBox

    Hi,

    I do not understand why when I enter 0.05 into thc_ and 0.1 into thc_ the result come out as 0.33 instead it should come out 0.11.

    where is my mistake here?

    HTML Code: 

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Wrong Result Come out on TextBox

    Perhaps your forumla

    1 / (1+((0.05)*4)*(1/(0.1)))

    retuns 3.3333333333, so it is correct.

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Wrong Result Come out on TextBox

    What is the formula you are trying to code. It's hard to tell where there might be a misplaced/missing "()"
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    03-08-2016
    Location
    Malaysia
    MS-Off Ver
    MS Office 2010
    Posts
    5

    Re: Wrong Result Come out on TextBox

    The formula is as below. the "h" basically a constant 4, the "lin" is htc_ and "lamdain" is htc_

    when I input htc_ as 0.1 and thc_ as 0.05, the actual value should be 0.11.

    It turns out the answer is 0.33

    r-insulated.JPG

  5. #5
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Wrong Result Come out on TextBox

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by protonLeah; 03-09-2016 at 02:14 AM.

+ 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 2010 – VBA Userforms – Vlookup via Textbox, display result in another textbox
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2015, 12:31 AM
  2. [SOLVED] Code result wrong but formula correct result
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-11-2014, 12:26 PM
  3. IF/Then Getting Wrong Result
    By artiststevens in forum Excel General
    Replies: 2
    Last Post: 01-06-2011, 07:21 PM
  4. excel result return wrong calcuation result
    By garyww in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2006, 06:20 AM
  5. Whatever I do I get the wrong result
    By Arishy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-20-2005, 01:40 PM
  6. Result in Cell is Wrong
    By Lilbit in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 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