Hi,
Can anyone assist me with the following formula please?
=IF(AND(J9="Pass",K9="Pass",L9="Pass"),"Pass","Fail")
This will basically say if cells J9, K9 and L9 have the value "Pass", then M9 will say "Pass". If not, it will say "Fail".
I want to add an additional part that will say if J9, K9 and L9 are blank, leave M9 blank.
How can I do this?
Thanks
Dave
Bookmarks