Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hi,
New to the forum as I am looking for an answer on using one field to change another. Not the sharpest tool in the shed so would appreciate any help. I have created a merge document to send to tenants when it is time to renew their lease. If they don't renew the lease they go to a month-to-month payment at an increased rent of $20.00 more per month. I have inserted a field to show the current rent, say $500.00. How do I make a second field to show that the rent will increase to $520.00 if they don't renew the lease and go to a month-to-month payment schedule? Thanks for any help available. |
#2
![]() |
|||
|
|||
![]() Quote:
This is what I did, I hit ALT+F9 to get squiggly parenthesis entered {={ MERGEFIELD monthly_rent }+20} monthly_rent was the name of my field in the document seems to be working great. Last edited by Rounder : January 30th 14 at 06:18 PM |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
NEED HELP !!!!! Add another formula to the Mail Merge Forumla IF | Mailmerge | |||
Multiplying a mail merge formula | Mailmerge | |||
Mail Merge Formula - Logic Stumped | Mailmerge | |||
Create formula using a merge field | Microsoft Word Help | |||
Date formula in merge | Mailmerge |