Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 Thanks Graham. |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mail Merge Formula - Logic Stumped | Mailmerge | |||
Multiplying cell values from different tables | New Users | |||
Multiplying cell values from different tables MS Word 2003 | Tables | |||
Quick access toolbar multiplying | Microsoft Word Help | |||
multiplying two fields in word table | Microsoft Word Help |