Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-26-2020, 03:18 AM
macropod's Avatar
macropod macropod is offline IF Statement not working Windows 7 64bit IF Statement not working Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

All you need is:
{IF{Mergefield Selected_Product_Frequency}<> "Bi-Weekly" "Late Charge: If a payment is {IF{Mergefield Opportunity_Borrower_Type}= "Refinance" "late by more than 15 days, you shall be subject to a late fee of $15.00." {IF{Mergefield Opportunity_State}= "SC" "15 days late, you will be charged $18.00 or 5% of the unpaid payment amount (A minimum of $7.20 and a maximum of $18.00)." {IF{Mergefield Opportunity_State}= "NM" "15 days late, you will be charged the lesser of $10.00 or 5% of the unpaid payment amount." {IF{Mergefield Opportunity_State}= "TX" "late by more than 10 days, you may be charged the greater of 5% of the delinquent installment amount or $7.50." "late by more than 15 days, you shall be subject to a late fee of $15.00."}}}}"}

The added part is shown in red.

Note: You don't need any of the Mergeformat switches; they add nothing useful to the process. I've also simplified the rest of your field coding somewhat.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting a Select statement in Excel to an update statement shabbaranks Excel Programming 5 10-31-2018 11:47 PM
Tasks Switch to Non-Working Days on Working Calendar danelloc Project 3 10-02-2017 12:38 PM
Help with IF statement kevinU Excel 0 03-15-2017 02:11 PM
IF Statement not working IF statement mrry475 Excel 1 09-06-2016 09:30 AM
IF Statement not working IF Statement teza2k06 Excel 1 03-11-2015 12:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft