Nested IF with COUNTBLANK

[Duckface49]

=IF(COUNTBLANK(D4:G4=0),(IF(COUNTBLANK(H4:K4=0),(IF(COUNTBLANK(L4:O4=0),"Distinction","Merit","Pass","Not Passed")))))

If certain cells aren't blank then the formula should check if the next set aren't blank and then finally check the last set. If all 3 aren't blank then return Distinction, if not then Merit and so on

Obviously I've messed up, but am struggling to see where

Please help!

Thanks

 

[shaowu459]

I don't quite sure your logic, but your formula should be like this:

=IF(COUNTBLANK(D4:G40)=0,IF(COUNTBLANK(H4:K4)=0,IF(COUNTBLANK(L4:O4)=0,"Merit","Distinction"),"Pass"),"Not Passed")

Change the sequence of Merit, distinction, pass, not passed as appropriate.

 

[Duckface49]

Perfect! I see it now, thanks very much

 

[shaowu459]

thanks for you feedback