Formula to get a value based on 2 cells data

[rfcapinto]

I searched the forum and did not find an answer to this, so I'm asking for advice on how to achieve the following:

I have 3 columns, A and B for the values (which only accept S or N as values) and C, that will return a value based on the values on A and B

IF A and B have "S", C will have IN
IF A or B have "N", C will have OUT (in this case if either A or B also are "blank" it will result in OUT on C)

As an example here goes a link
https://docs.google.com/spreadsheet/...nR1d3VEQ0RfMFE

Sorry if i was not too clear, ask any questions.

Thank you!!

[ChemistB]

=IF(A2="S",B2="S","IN",IF(COUNTA(A2:B2)>=1,"Out","") dragged down
Does that work for you?

[Cutter]

Try

=IF(COUNTIF(A2:B2,"S")=2,"IN",IF(COUNTIF(A2:B2,"N"),"OUT",""))

[rfcapinto]

Try
=IF(COUNTIF(A2:B2,"S")=2,"IN",IF(COUNTIF(A2:B2,"N"),"OUT",""))

This one did the job,

thank you!

[Cutter]

You're welcome.