Multiple IF statement issue

macropod · #1 03-27-2024, 06:23 AM

Quote:

Originally Posted by TessaMurillo

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"))

That's all very well if you're using Excel, but Word has no ISBLANK field function. Your formula syntax is wrong for Word, too.

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