3 condititon for a output

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

i need to check 3 condition for one output how can i check by usu=ing Excel fomula.

Ex
Condition for output of Cell D1

A1 = "R" & B1="R" & C1"R"

If all the three conditions are fullfilled then Cell D1 shows " Non "
Otherwise leave as blank.

Senthil Raja
Chennai

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
=IF(AND(A1="R", B1="R", C1="R"), "Non", "")


or

=IF(A1="R", IF(B1="R", IF(C1="R", "Non", ""), ""), "")

or

=IF(A1 & B1 & C1 = "RRR", "Non", "")