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!

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.

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


"Steve" wrote in message ...
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!