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" }}
What I can't seem to get working is a further step. When I try and insert another nest to the above it doesn't seem to work.
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}
Any help is greatly appreciated.