this my homework excel about multiple if… please help me
Result colomn will be ACCEPT IF Age below or equal 32, grade S1, English yes, IPK minimum 4,00 , tes minimum 80, interview good, Other than that Not Accept
this link is sample
>Solution :
You can use if with and.
Also if, you want, you can use ifs.
=if(and(b2<=32,c2=51,,d2="yes",e2>=4,f2>=80,g2="good"),"other","not accept").