You have to create each field (anything between braces) using Ctrl+F9.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Glenn" wrote in message
...
When I insert 1 of those into the formula it does not return anything.
After
I click ok on the formula window, it just closes like I did not even add
anything in.
I must be doing something wrong??--
Thanks for the help,

Glenn


"macropod" wrote:

Hi Glenn,

If your business rules are such that all balances after the first 0
balance
are 0 also, you could use:

{={Bal1}*({Bal2}=0)+{Bal2}*({Bal3}=0)+{Bal3}*({Bal 4}=0)+{Bal4}*({Bal5}=0)+{B
al5}*({Bal6}=0)+{Bal6}}
or even:

{=Bal1*(Bal2=0)+Bal2*(Bal3=0)+Bal3*(Bal4=0)+Bal4*( Bal5=0)+Bal5*(Bal6=0)+Bal6
}
No IF tests are required for these.

Alternatively, if you could have 0 balances interspersed with non-0
balances, you could use:
{IF{Bal6} 0 {Bal6} {IF{Bal5} 0 {Bal5} {IF{Bal4} 0 {Bal4}
{IF{Bal3} 0
{Bal3} {IF{Bal2} 0 {Bal2} {Bal1}}}}}}
or, if the non-0 balances are always +ve:
{IF{Bal6} 0 {Bal6} {IF{Bal5} 0 {Bal5} {IF{Bal4} 0 {Bal4} {IF{Bal3} 0
{Bal3} {IF{Bal2} 0 {Bal2} {Bal1}}}}}}

Cheers


"Glenn" wrote in message
...
I have a mail merge doc that could have 6 records with Balances in
them.
What I have that works for the first 2 records; =IF(Bal20,Bal2,Bal1).
Basicaly I want the last record that has a value 0 to print. How do
I
get
this to look at all 6 records, or am I doing this the wrong way?
--
Thanks for the help,

Glenn