7 Multiple IF formula in excel don't work i saw many false

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

enter image description here

>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").

Leave a Reply