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
Bookmarks