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