Previous Topic Next Topic

3 condititon for a output

Closed
Raja - Mar 6, 2010 at 02:58 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 8, 2010 at 08:38 AM
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
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 8, 2010 at 08:38 AM
=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", "")
0