Outlook Formula Help

[Steve]

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]]

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.