A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Multiplying a mail merge formula

Thread Tools Display Modes
Old August 13th 13, 04:42 PM
Grazza215 Grazza215 is offline
Junior Member
First recorded activity by WordBanter: Aug 2013
Posts: 1
Default Multiplying a mail merge formula

Hi guys,

Really hoping someone can help

I've been trying to get this to work, but seem to be missing a trick.

I am using a series of mergefields (linked to a CSV data sheet) and have this working fine:

{ = { mergefield "debits_H"} - { mergefield "EXPCT_AMT2"\#,0.00 } + { mergefield CUR_AG_PAMT }}

This gives me:

Amount 1 - Amount 2 = Amount 3

I need to be able to multiple the above "Amount 3" forumla by 2, 4 and 52/12 (It is a formula for working out rent charges - so a fortnightly, 4 weekly, and monthly figure.)

I need to get:

Amount 1 - Amount 2 = Amount 3 * 2

I've tried various incarnations and dont seem to be able to get it right - even though I think I've followed all the previous rules.

Has any one got any ideas?

Would really appreciate any help



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Formula - Logic Stumped MaxArk[_28_] Mailmerge 2 June 1st 10 11:11 AM
Multiplying cell values from different tables shameerau New Users 1 August 31st 09 10:12 AM
Multiplying cell values from different tables MS Word 2003 Shameer A U Tables 1 August 31st 09 10:09 AM
Quick access toolbar multiplying J Weir[_2_] Microsoft Word Help 1 March 19th 08 07:44 AM
multiplying two fields in word table lth Microsoft Word Help 1 October 2nd 07 06:43 PM

All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.