PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook VBA Programming Display result from Outlook formula.

Reply

Display result from Outlook formula.

 
Thread Tools Rate Thread
Old 04-12-2007, 08:26 AM   #1
Elisabeth
Guest
 
Posts: n/a
Default Display result from Outlook formula.


How do I get the result of a formula calculation to display in rounded
numbers, not decimals. For example I have figured out how to use the FV
foumula for future value and can plug in fields, but the result is a long
number with four decimals and I would prefer to just see a result rounded to
whole number.
  Reply With Quote
Old 04-12-2007, 01:13 PM   #2
Sue Mosher [MVP-Outlook]
Guest
 
Posts: n/a
Default Re: Display result from Outlook formula.

YOu can use the Round() function to round the result: Round(value, number_of_places)

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Elisabeth" <Elisabeth@discussions.microsoft.com> wrote in message news:909FDDBA-5FB9-4F51-BC63-323C81746119@microsoft.com...
> How do I get the result of a formula calculation to display in rounded
> numbers, not decimals. For example I have figured out how to use the FV
> foumula for future value and can plug in fields, but the result is a long
> number with four decimals and I would prefer to just see a result rounded to
> whole number.

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off