Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-21-2024, 02:01 PM
Ren1975 Ren1975 is offline Multiple IF statement issue Windows 10 Multiple IF statement issue Office 2010
Novice
Multiple IF statement issue
 
Join Date: Mar 2024
Posts: 9
Ren1975 is on a distinguished road
Lightbulb Multiple IF statement issue

Good morning,



I am wondering if someone can help me solve how to format an IF statement for multiple conditions? I am usually ok with this, but I am going around in circles with this one.
This is what I am trying to achieve -

IF (DAName1) has data, but (DAName2) doesn't, I need it to return "(DAName1) has been added to your policy as a delegated authority and can now access your information and make claims on your behalf"

IF (DAName1) and (DAName2) both contain data, I need it to return "(DAName1) and (DAName2) have been added to your policy as delegated authorities and they now have access to your information and can make claims on your behalf"

IF (DAName1) and (DAName2) are both blank, I need it to return nothing.

Any assistance would be greatly appreciated.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2019: How to apply if statement for multiple values? Jamal NUMAN Excel 2 02-27-2021 01:11 AM
Multiple IF statement issue Multiple actions in an IF statement IanT Mail Merge 4 01-15-2021 03:13 AM
Multiple Projects in Multiple timelines Issue szimmer100 Project 0 11-12-2019 12:11 PM
Converting a Select statement in Excel to an update statement shabbaranks Excel Programming 5 10-31-2018 11:47 PM
Multiple IF statement issue Using multiple conditions with an IF statement?? to show a yes/no value BlindMouse Excel 1 01-27-2016 12:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:34 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