Rounding Currency

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello MVP's
Is there a way that I can round this formula that I have for a control source
of a textbox
txtSubTotal value = 3.15
Textbox1 ControlSource =Nz([txtSubTotal]*0.0675,0)
So instead of this $0.2126
I would get this $0.21
The Textbox that I have the formula in looks like $0.21 but I have a command
button that adds this the Textbox value to a subform which turns the 0.21 to
0.2126
 
There is a ROUND function which allows you to specify to how many decimal
places you want to round.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average If 3
Rounding Numbers 4
Help wCombo Box Setup 1
two value axes in an excel line chart 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Currency formula/formatting problem 4
Expression evaluation 3
custom currency symbol independent of regional settings 1

Back
Top