• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need some help with calculations

When I fill in the first textbox (textbox1) and i push the button 'bereken U-waarde binnenwand' then the calculation is correct but when i fill more textboxes (2, 3, 4 or 5) then the callculations are not correct anymore.
Someone please help
File included
Thanks in advance
 

Attachments

  • Kopie van berekenen Rc en U.xlsm
    23.6 KB · Views: 2
Try nesting each of TextboxX.Value in Val(). Otherwise, you'll probably get Type mismatch error.
 
I'm assuming Belleke & dochieJack is one and same person...

Unless your calculation itself is off. I'm getting the correct answer by nesting it in Val().
upload_2016-8-8_13-18-17.png

See attached as well.

If this isn't the correct answer, I'd recommend posting arithmetic calculation broken out in steps (ex. 0.5 + 0.2 + 0.17 = 0.87; 0.87/1.05 = 0.828571...; 0.828571... - 0.17 = 0.658571...).
 

Attachments

  • Kopie van berekenen Rc en U.xlsm
    26.4 KB · Views: 3
I'm assuming Belleke & dochieJack is one and same person..
Not realy, Belleke is my daughter, I was cooking;), so I asked her to answer.
Thank you for your answer, I will test it an come back to you
 
Back
Top