I am looking for some expertise on a formula in cell E15 that would look at data in cell A1 or A2 ad return an answer.
<tbody>
Cell #A1 – can possibly be blank, YES, NO or NA
Cell #A2 – can possibly be blank, YES, NO or NA
If either A1 or A2 is blank; then leave cell...