Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Results of multiplying

Status
Not open for further replies.
vlitim

vlitim

Programmer
Sep 2, 2000
393
GB
if I have two numbers say

1.234567 * 2.987 = 3.687651629

what happens if I only want to display the answer to two decimal places?

ie 3.69

??

 
Sort by date Sort by votes
dim result

result = round((1.234567 * 2.987), 2)

The 2 being the number of decimal places you would like to have the result rounded off to...

good luck! :)
Paul Prewett

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
316
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
First execute an input command and only then proceed with displaying the next record of the table
Replies
0
Views
283
leifoet
leifoet
leifoet
  • Locked
  • Question
How to update the content of radio buttons in a database?
Replies
2
Views
189
leifoet
leifoet
penguinspeaks
  • Locked
  • Question
2 columns of data
Replies
0
Views
151
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
How to display the contents of a drop-down list in a column structure ?
Replies
2
Views
155
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top