IF/OR Dilemma

[js65572]

Hi everyone,

I'm relatively new to formula chat so please bear with me,

I'm trying to create a report that separates amounts if failing/succeeding on a system,

Simply put, if there is data in a certain column (J) I have column (L) turn red and say the word "Fail" if no data is in column (J) it says "OK" in column (L)

Now this is all well and good but now I have an issue. This report is for separating amounts based on credit and debits. If column (A) has the word "Debit"/"Credit" in it and column (L) as above is in "Fail"/"OK" status can I have another column (M) tell me if I have a "Credit"/"Debit" and whether it's in "Fail" status or "OK"

Thank you in advance

 

[Radar96]

Put this in column J: It checks to see if the cell has anything in it to reply Fail/Ok
=if(J2="","Fail","Ok")

In M: This will check for the word Debit and return Ok, otherwise it will return Fail.
=if(A2="Debit","Ok","Fail")

 

[js65572]

Sadly I will have data in column J already therefore I cannot use a formula in it. Currently I am using this
=IF(J2:J48>0,"Fail","OK") which generates the word "Fail" or "OK" in column L.

Column A will also have either Credit or Debit in it numerous times. I am just trying to single out "Fail" trades apparant in column L and whether it be for "Credit" or "Debit" (column A) and then let me know in column M

Thanks

 

[Radar96]

If you move my first formula into column L and copy the formula into the other cells in the row. Making sure it becomes J2, J3, J4 etc.

 

[js65572]

I already have the formula =IF(J2:J48>0,"Fail","OK") in column L which is working without any issue, it is correctly looking for data in column J and informing me whether my trade is failing or is ok,

The issue I have is in column M, I want column M to look in column A for "Credit or "Debit" then use the "Fail" or "OK" status from column "L" to generate a specific message (CREDITFAIL/DEBITFAIL/CREDITOK/DEBITOK)

Thank you

 

[Radar96]

Have you tried:
=A2&L2
That should give you the reponses you are looking for.

 

[js65572]

Perfect, thank you

Couldn't see the woods for the trees haha