| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF's & AND's
--------------------------------------------------------------------------------
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF's & AND's
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Too many 'if's! | Excel Discussion (Misc queries) | |||
| Too Many If's | Excel Worksheet Functions | |||
| SUMPRODUCT with AND's and OR's? | Excel Worksheet Functions | |||
| How many 'if's'? | Excel Discussion (Misc queries) | |||
| How many if's? | Excel Discussion (Misc queries) | |||
Linear Mode
