Solved

IF/OR Statement

Posted on 2011-02-15
4
289 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:Seamus2626
4 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 34898161
=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
 
LVL 11

Expert Comment

by:Runrigger
ID: 34898182
=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
 

Author Closing Comment

by:Seamus2626
ID: 34898188
Thanks Rory

Cheers
Seamus
0
 
LVL 45

Expert Comment

by:patrickab
ID: 34898231
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now