Hello @shia1700,
Try this formula out:
=IF(AND(F3=TRUE,F9=TRUE,F4:F8=FALSE,F10:F11=FALSE,G3:G10=FALSE),"MBA",IF(AND(F3=TRUE,F9=TRUE,F10=TRUE,F4:F8=FALSE,F11=FALSE,G3:G10=FALSE),"NA",IF(AND(G3:G4=TRUE,F3:F11=FALSE,G5:G10=FALSE),"XBA",IF(AND(F9:F10=TRUE,F3:F8=FALSE,G3:G10=FALSE),"both","NO RESULT"))))
This is an array formula so you will have to press ctrl+shift+enter.
Hope this helps!