Thread: [Solved] Multiple IF statement issue
View Single Post
 
Old 03-27-2024, 06:23 AM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,465
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
Quote:
Originally Posted by TessaMurillo View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote