Math Issue

[rockchalk33]

Hey all so I had recently finished up a job and the recipient had emailed me and showed that there is a problem with my multiplication. I'm on my way to troubleshoot now but here's the issue. Assume a rate of $10/hour. There is a textbox to enter how many hours a particular person had worked. The Userform then takes the textbox value and multiplies it by the $10/hour rate and puts that product into column B. Obviously this is a variable range but below is an example of what the code looks like:

Range("B2") = TextBox1.Value * 10

Seems fairly straightforward except if this person works in half hour increments (example would be 10.5 hours)...the math doesn't recognize the 0.5 hour increment and would instead give a value of $100 instead of $105.

I am on my way to troubleshoot now, can anyone give a rough estimate as to what might be causing this problem?

 

[silentwolf]

Hi,
you need to deklare a varible with double instead of integer then it will reconize the 10.5

 

[MattH1]

Hey all so I had recently finished up a job and the recipient had emailed me and showed that there is a problem with my multiplication. I'm on my way to troubleshoot now but here's the issue. Assume a rate of $10/hour. There is a textbox to enter how many hours a particular person had worked. The Userform then takes the textbox value and multiplies it by the $10/hour rate and puts that product into column B. Obviously this is a variable range but below is an example of what the code looks like:

Range("B2") = TextBox1.Value * 10

Seems fairly straightforward except if this person works in half hour increments (example would be 10.5 hours)...the math doesn't recognize the 0.5 hour increment and would instead give a value of $100 instead of $105.

I am on my way to troubleshoot now, can anyone give a rough estimate as to what might be causing this problem?

Good afternoon Rockchalk,

It seems you've declared TextBox1 an Integer. In the case of 10.5, it'll automatically make it 10 and therefore you'll receive the answer of 100.

In your coding, you should see: Dim TextBox1 as Integer
Change that to this: Dim TextBox1 as Double

 

[Rick Rothstein]

Hey all so I had recently finished up a job and the recipient had emailed me and showed that there is a problem with my multiplication. I'm on my way to troubleshoot now but here's the issue. Assume a rate of $10/hour. There is a textbox to enter how many hours a particular person had worked. The Userform then takes the textbox value and multiplies it by the $10/hour rate and puts that product into column B. Obviously this is a variable range but below is an example of what the code looks like:

Range("B2") = TextBox1.Value * 10

Seems fairly straightforward except if this person works in half hour increments (example would be 10.5 hours)...the math doesn't recognize the 0.5 hour increment and would instead give a value of $100 instead of $105.

I am on my way to troubleshoot now, can anyone give a rough estimate as to what might be causing this problem?

Off the top of my head, I expect you will find the Cell Format for cell B2 to be Number with zero decimal places or Custom Formatted as # or 0.

Edit Note: Or you will find the column width is too narrow to show the decimal place.

 

[rockchalk33]

Awesome! I'll be sure to check all the above!