Excel Macros Add Multiply and Divide

[mehul13]

Hello everyone,
I want to perform the following function

Like i have a value on my Base price text box i.e 2500
I have a value in my Tax amount i.e 2%
Now i want my Total textbox to print the value of ((2500 + (2500*2/100))
How do i do it..?
Please Help

I tried something but its now happening
Thank you in advance
My Code is

Private Sub Textbaseprice_Change()


End Sub


Private Sub Texttaxamount_Change()



End Sub


Private Sub Texttaxes_Change()
If Me.Texttaxes = "CST" Then Me.Texttaxamount = "2%" Else Me.Texttaxamount = "15.6%"


End Sub


Sub GetSum()
On Error Resume Next
Me.Texttotal = (IIf(Me.Textbaseprice = "", 0, Me.Textbaseprice) + 0) + (IIf(Me.Texttaxamount = "", 0, Me.Texttaxamount) + 0)
End Sub


Private Sub Texttotal_Change()
If Me.Texttaxeamount = "" Then Me.Textttotal = "" Else Me.Texttotal = "Call Totalin"

End Sub


Sub Totalin()
Dim total As Double
total = Val(Textbaseprice.Value) + (Val(Textbaseprice.Value) * Val(Texttaxamount.Value) / 100)
Me.Textbaseprice.Value = ""
Me.Texttotal.Value = total
End Sub

 

[xlhelp15]

Could you please elaborate your issue as more?

is this you required the ans. in textbox3?

 

[mehul13]

Could you please elaborate your issue as more?

is this you required the ans. in textbox3?

Yes.. I wanted that the final ans
((2500)+(2500*2/100))
Comes in textbox3
Actually
Textbox1 has value 2500
Textbox2 has 2%
So
Textbox3 should give an ans automatically of
((2500)+(2500*2/100))

 

[xlhelp15]

Yes.. I wanted that the final ans
((2500)+(2500*2/100))
Comes in textbox3
Actually
Textbox1 has value 2500
Textbox2 has 2%
So
Textbox3 should give an ans automatically of
((2500)+(2500*2/100))

you can place this in your command button_click method,

TextBox3.Value = (TextBox1.Value + (TextBox1.Value * TextBox2.Value / 100))

 

[mehul13]

you can place this in your command button_click method,

TextBox3.Value = (TextBox1.Value + (TextBox1.Value * TextBox2.Value / 100))

Thank you so much... I did that only..
Thank u for ur response..