Calculations inside nested if statements

T

Tom

Hi I am using word 2007. I have a mail merge in which I am using nested if
statements . I want to assign a customer discount for the balance based on
the city of residency. For example, If they live in Akron , I want the bill
reduced by 10%. If they live in Cleveland I want the bill to be reduced by
12% and so on.

I have a field called TotalAccountBalance that is being passed back to word
from an access database calculated query. I tried {if{city}="Akron"
"{TotalAccountBalance}-{Total Account Balance *.10}" and so forth. I believe
this can be done. Can anyone help? Thanks

Tom
 
S

Suzanne S. Barnhill

I guess the "Can anyone help?" (which I thought was odd phrasing) should
have been the tipoff that your identical question directed to me at
AllExperts (which I have answered) was not directed to me alone. <sigh>

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
 
T

Tom

I apologize for the cross posting. I was just trying any available resource
to find an answer quickly. Your answer was greatly appreciated.
Tom
 
S

Suzanne S. Barnhill

I just happened to get the email before I saw this NG; otherwise the answer
would have been here first. But I suppose it would have been helpful if the
AllExperts question had mentioned that you had also posted the question to
the NG. In that case, I think I would have preferred to reply here, for the
benefit of more users (especially since your AE question was posted as a
"private" one).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top