Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming Forms / September 2007

Tip: Looking for answers? Try searching our database.

Outlook Formula Help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve - 18 Sep 2007 17:04 GMT
Hi, I'm having some trouble with Outlook Formulas.  I'm trying to use the
formula in my form to add the results of four formulas.  Here's what I've put
in the formula:

[NPR]+[NPT]

Each one of these fields is itself a formula and I want Outlook to add the
results of the two formulas together.  Instead, it simply displays the two
results side by side, like this:

$395.00$45.00

So instead of adding the two, I'm stuck with this.  Anyone know how to
overcome this little problem.  I have the feeling I'm missing something
obvious.

As well, is there a comprehensive list and explanation of the Outlook
formula functions out there, I can figure out quite a few of them, but not
all and none of the Outlook books I have explain each function.

Thanks!
Sue Mosher [MVP-Outlook] - 18 Sep 2007 17:24 GMT
Try using a conversion function:

   CCur([NPR]) + CCur([NPT])

All the functions have equivalents in VBA, I think, so you can look them up there.

Signature

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

> Hi, I'm having some trouble with Outlook Formulas.  I'm trying to use the
> formula in my form to add the results of four formulas.  Here's what I've put
[quoted text clipped - 17 lines]
>
> Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.