Calculations inside nested if statements

[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

 

[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

 

[macropod]

Answered by me in microsoft.public.word.vba.general too!

Tom: Please see http://www.excelguru.ca/node/7

 

[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

 

[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