Hi there

Please can someone advise the best way of having a cell automatically turn true or false depending on other cells.

I need cell A5 to contain TRUE, FALSE or a nil value

If cells B5:D5 contain NA or Yes, I need cell A5 to state TRUE

If any of cells B5:D5 contain NO, then I need cell A5 to contain FALSE

Many thanks