Solved: Syntax calculation error

[bopo]

Hi people


Basically I want to add the values of two textboxes together, and then multiply that value via a number in a different textbox

here is similar code to mine



txttotalcost.Text = txtcost1 + txtcost2 * people


however, assume the following

txtcost1 = 10
txtcost2 = 10
people = 2

the obvious answer is 40, however it comes up with 30, its the same for all types of numbers.

[mdmackillop]

Add .Value as in
Label1.Caption = TextBox1.Value * TextBox2.Value * TextBox3.Value

[Bob Phillips]

txttotalcost.Text = (txtcost1 + txtcost2) * people

[bopo]

Thanks for help however using the above senario:

' txtcost1 = 10
txtcost2 = 10
people = 2'

I am getting a result of 200 using both methods, anu ideas?

[gnod]

use the code from xld. you need to use parenthesis in order to override the rules of precedence of operators..

[bopo]

Well using that, I am getting 1010 any help?


edit: I kind of resolved this using a little cheat, but I want it to display to two decimal values such as 10.00, any ideas?

[Bob Phillips]

txttotalcost.Text = Format((Val(txtcost1.Text) + Val(txtcost2.Text)) * people,"#,##0.00")

[bopo]

Works perfectly, thanks :D