Accuracy

[Baked_potato]

Hello experts,


I badly need help on this problem.

I have 3 textboxes : Textbox1 , textbox2, textbox3.

I want to do the subtraction:

Textbox3.value = texbox1.value - textbox2.value

1.034 - 1.035 =-0.001

I was expecting -0.001 is the answer but the textbox3 displayed like this ( see the picture )

Many thanks in advance.

 

[mackc557]

Are these the only text boxes you have on the userform?
- The names in the equation may be referring to other textboxes
Is the code copied directly from your module?
- Textbox1.value is missing the second "t"
Are you setting default values as the userform is initialized?
- You might have some other random default data in there
When are you calculating the Textbox3?
- It might be that the calculation is happening before all the data is entered

Just some things to look into and to provide us all with more information.

 

[Peter_SSs]

I suspect it is a floating point rounding issue - see the links below.
Try this calculation instead (checking your spelling as already suggested)

Textbox3.value = Round(Textbox1.value - Textbox2.value, 3)

Floating-point arithmetic may give inaccurate result in Excel - Office
Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?” - Microsoft 365 Blog

 

[bebo021999]

Is "1.034" number "1034" (one thousand and thirty four)?
And "1.035" number "1035.0000000000001"?
textbox 2 maybe result from formula?

 

[Baked_potato]

Is "1.034" number "1034" (one thousand and thirty four)?
And "1.035" number "1035.0000000000001"?
textbox 2 maybe result from formula?

Hi sir,

Textbox1 = 1.034 only
textbox2 = 1.035 only

textbox3 is the difference of textbox1 minus texbox2

 

[Baked_potato]

I suspect it is a floating point rounding issue - see the links below.
Try this calculation instead (checking your spelling as already suggested)

Textbox3.value = Round(Textbox1.value - Textbox2.value, 3)

Floating-point arithmetic may give inaccurate result in Excel - Office
Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?” - Microsoft 365 Blog

Thank you very much sir.

 

[Peter_SSs]

Thank you very much sir.

You're welcome. Thanks for the follow-up.