#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Is this for a macro or a field?
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
Hi it is for a field
|
#4
|
|||
|
|||
Thanks for your help but I have now figured this out
|
#5
|
||||
|
||||
The basic structure is
{If DAName1 {If DAName2 "Result for both DAName1 and DAName2" "Result for only DAName1"} ""}
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#6
|
|||
|
|||
Thank you
|
#7
|
|||
|
|||
To achieve your goal you need to use the IF function in Excel with multiple conditions
=IF(AND(ISBLANK(DAName1), ISBLANK(DAName2)), ", IF(ISBLANK(DAName2), DAName1 & " has been added to your policy as a delegated authority and can now access your information and make claims from your name", DAName1&" and "&DAName2&" have been added to your policy as delegated authority and they now have access to your information and can make claims on your behalf")) This formula works like this: Checks if both (DAName1) and (DAName2) are empty. If both are empty, an empty string is returned. If (DAName1) contains data and (DAName2) does not, a message is returned indicating that (DAName1) has been added. If both (DAName1) and (DAName2) contain data, a message is returned indicating that both have been added. Hope this helps! |
#8
|
|||
|
|||
Great thank you Tessa, much appreciated
|
#9
|
||||
|
||||
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
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 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 |
Using multiple conditions with an IF statement?? to show a yes/no value | BlindMouse | Excel | 1 | 01-27-2016 12:19 AM |