IF/OR Statement

Hi,

I have attached an IF/OR Statement that needs to be modified so that where there is no narrative in AP, it says "No Narrative Provided" in AO

Thanks
Seamus
Example.xls
Seamus2626Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rory ArchibaldConnect With a Mentor Commented:
=IF(OR(AP2={"","Fidessa Booking instructed, Awaiting Sophis Booking","Re - Allocated to different Source code","No Narrative Provided","Open Investigation","fidessa booking to be made","Corporate Actions Booking Adjustment required","Paris involved in resolution","New break requires investigatation (1 - 3 day)"}), "No Narrative Provided",AP2)

should do it.
0
 
RunriggerCommented:
=IF(OR(AP2="Fidessa Booking instructed, Awaiting Sophis Booking",AP2="Re - Allocated to different Source code",AP2="No Narrative Provided",AP2="Open Investigation",AP2="fidessa booking to be made",AP2="Corporate Actions Booking Adjustment required",AP2="Paris involved in resolution",AP2="New break requires investigatation (1 - 3 day)",AP2=""), "No Narrative Provided",AP2)
0
 
Seamus2626Author Commented:
Thanks Rory

Cheers
Seamus
0
 
patrickabCommented:
Try:

=IF(OR(AP2="Fidessa Booking instructed, Awaiting Sophis Booking",AP2="Re - Allocated to different Source code",AP2="No Narrative Provided",AP2="Open Investigation",AP2="fidessa booking to be made",AP2="Corporate Actions Booking Adjustment required",AP2="Paris involved in resolution",AP2="New break requires investigatation (1 - 3 day)",AP2=""), "No Narrative Provided",AP2)

It's in the attached file.

Patrick

Copy-of-Example-3.xls
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.