You could use an AND function along with IF.

=IF(AND(B1="Y",B2="Y",B3="Y"),"True","False")

Not sure what specifics you want.

Regards,
Paul

--

"Aline" wrote in message
...


How could I put up a IF function with multi-conditions?

Y for "Meets", "Mostly Meet" and "Exceeds"
N for "Not Meet" and "unable to assess"
No Info for no content in cell

****************

Meets Y
Mostly Meet Y
Exceeds Y
No Info
Not Meet N
Unable to assess N
Meets Y
No Info
Not Meet N

****************

Thanks,
Aline


--
Aline