Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-15-2024, 11:53 PM
mross mross is offline How do i combine multiple conditions / rules Windows 11 How do i combine multiple conditions / rules Office 2021
Novice
How do i combine multiple conditions / rules
 
Join Date: Jan 2024
Posts: 1
mross is on a distinguished road
Question How do i combine multiple conditions / rules


I am extracting a description for my mail merge ..
{ if {mergefield description} = "instalment interest''Instalment cost" "{description")

this works as expected but I want to add, if mergefield description = Power, then exclude , as I don't want to see that line at all. I don't know how to exclude, I've tried skipif, but that has not worked. All i can get is a line, with no data on it . Please help
Reply With Quote
  #2  
Old 01-19-2024, 05:46 PM
macropod's Avatar
macropod macropod is offline How do i combine multiple conditions / rules Windows 10 How do i combine multiple conditions / rules Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

{IF{MERGEFIELD description}= "Power" "" {IF{MERGEFIELD description}= "instalment interest" "Instalment cost" {MERGEFIELD description}}}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
#ifelse, #skipif



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i combine multiple conditions / rules Combine Multiple Documents from Multiple Folders while also inserting title Lumberjax Word VBA 14 03-07-2023 07:12 AM
How do i combine multiple conditions / rules Can you combine two Rules in one Mail Merge Command coopfab Mail Merge 4 11-04-2019 01:08 PM
How do i combine multiple conditions / rules SKIPIF with multiple conditions and 0 and 1? jasendill Mail Merge 1 11-01-2019 11:36 PM
Alternative for Multiple If Conditions? zguan1 Excel 2 05-25-2017 09:12 AM
How do i combine multiple conditions / rules Multiple If Conditions z941714 Excel 8 08-09-2015 04:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:54 PM.


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