ExcelBanter - IF's & AND's

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF's & AND's (https://www.excelbanter.com/excel-discussion-misc-queries/156875-ifs-ands.html)

--------------------------------------------------------------------------------

Hi,

Can anyone assist me with the following formula please?

=IF(AND(J9="Pass",K9="Pass",L9="Pass"),"Pass","Fai l")

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

Try this

=IF(COUNTA(J9:L9)<3,"",IF(AND(J9="Pass",K9="Pass" ,L9="Pass"),"Pass","Fai l"))

Mike

"Dave" wrote:

--------------------------------------------------------------------------------

Hi,

Can anyone assist me with the following formula please?

=IF(AND(J9="Pass",K9="Pass",L9="Pass"),"Pass","Fai l")

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