Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Wendy7 Wendy7 is offline
external usenet poster
 
Posts: 5
Default Complicated Formula - If statements

Hello,

I have a formula that on some merged records = $0.00. If this happens, I
would like for nothing to appear. I'm having trouble with the formula - I
tried an If statement around the original formula, but it still produced $0.00

Here's the original formula:
{={IF "{MERGEFIELD M_08_AP_Pledge}"="" "0" "{MERGEFIELD
M_08_Ascend_Pledge}"}} + {={IF "{MERGEFIELD M_08_Ascend_RGP}" ="" "0" "{
MERGEFIELD M_08_Ascend_RGP}" } } \# $,0.00}

I put the two If statements in the original formula to avoid a syntax error
for records that did not have data.

All help is welcome, thank you!
Wendy
 
Thread Tools
Display Modes

Posting Rules

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
complicated list numbering grammatim[_2_] Microsoft Word Help 8 December 27th 07 11:47 AM
Complicated Merge Joshann Mailmerge 5 April 25th 07 07:02 PM
Complicated (to me) merge [email protected] Mailmerge 2 October 11th 06 08:43 PM
how to align caption of formula right whereas formula itself left Martin van Leeuwen Microsoft Word Help 1 October 22nd 05 06:39 AM
complicated table of contents ben New Users 4 March 7th 05 02:35 PM


All times are GMT +1. The time now is 08:29 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"