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!