Hi,

I’d like to create a formula which looks at column A for a value containing ‘MD’ if it contains this then to go to column B AND C and if they both state ‘Complete’ then to return words in column D with ‘Case Closed’

If column A does not contain ‘MD’ then return a blank and not to move to the if statement or next stage.

If one of the two Column B and C contain any other words then column D should return words ‘Case Open’

Hope that all makes sense. Is this possible?

At the moment I have a formula which only looks at column B and C, this is the forumla with the actual column table headers:

=IF(AND([@[Servicing Status]]=”Complete”, [@[Complaint Status]]=”Complete”), “Case closed”, “Case Open”)

​Hi, I’d like to create a formula which looks at column A for a value containing ‘MD’ if it contains this then to go to column B AND C and if they both state ‘Complete’ then to return words in column D with ‘Case Closed’ If column A does not contain ‘MD’ then return a blank and not to move to the if statement or next stage. If one of the two Column B and C contain any other words then column D should return words ‘Case Open’ Hope that all makes sense. Is this possible? At the moment I have a formula which only looks at column B and C, this is the forumla with the actual column table headers:=IF(AND([@[Servicing Status]]=”Complete”, [@[Complaint Status]]=”Complete”), “Case closed”, “Case Open”)   Read More

​