Thread Tools Display Modes
  #1   Report Post  
Grazza215 Grazza215 is offline
Junior Member
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

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 06: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 07:00 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Word"