#1
|
|||
|
|||
Nested if statement using bookmark fields
If've got the below if statement which is producing the correct result. It has a dropdown with two options monthly or quarterly. Min_Term is another bookmark being a number of months eg 60.
Code:
{IF{ REF Dropdown1 \* MERGEFORMAT } = "Monthly" {=Min Term \#"#,##0.00"} {=Min_Term/4 \#"#,##0.00" }} I'm trying to get the result of the above and multiply it by another bookmark being Rental_bill_period. For example above if statement result = 60, and Rental_bill_period is 100, result is 6,000. This is what I'm trying to use Code:
{IF{ REF Dropdown1 \* MERGEFORMAT } = "Monthly" {=Min Term \#"#,##0.00"} {=Min_Term/4 \#"#,##0.00" }* Rental_bill_period} |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Nested Fields using Conga for Salesforce | new user | Mail Merge | 5 | 12-15-2022 04:02 PM |
REf Fields show Bookmark whole cell when Bookmark is created by code. | pmcpowell | Word VBA | 2 | 11-16-2019 07:05 PM |
Bookmark - add two merge fields | dfin | Word VBA | 5 | 09-06-2016 10:08 PM |
How to setup Nested If statement | bigukfan | Mail Merge | 4 | 04-30-2014 05:19 AM |
Form Fields - Create blank form text field with if statement? | LAssist2011 | Word | 5 | 12-14-2011 03:02 PM |