Nested IF statement with AND conditions

[kingcameron]

Hi Everyone

I have a datasheet that i want to add a column to based on the combination of what appears in two other columns.

ie, if columns J and H both say 'Positive', then i want to return 'TP' (True Positive), but if column J had 'Negative' and H was ' Positive', then it would be 'FN' (False Negative) etc.
photo below for context.
Excel.PNG

So effectively, it's 4 IF statements nested into one, but each has an AND as well. The formula ive tried to use is as follows:

=IF(AND(J2='Positive',H2='Positive'),'TP',IF(AND(J2='Positive',H2='Negative'),'FP',IF(AND(J2='Negative',H2='Negative'),'TN','FN')))

It just returns an error: There's a Problem with this Formula

Any help would be greatly appreciated

TIA

[Fluff13]

You need to replace the ' (single quote) with " (double quotes)

[kingcameron]

Thank you so much.
Been using Python for so long i forgot the difference haha

[Fluff13]

Glad to help & thanks for the feedback.

[JohnTopley]

Single quotes should be double quotes i.e " not '