Thread: i want to give more than 6 condition by using if statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sushil[_2_] Sushil[_2_] is offline
external usenet poster
  
Posts: 1
Default i want to give more than 6 condition by using if statement
when i am given the below condition it is given me an error, please help me
how to do it for the students details.

=IF(C4<35,"Fail",IF(D4<35,"Fail",IF(E4<35,"Fail",I F(F4<35,"Fail",IF(G4<35,"Fail",IF(H4<35,"Fail",if( j4<45,"Pass",if(j4<60,"Second
Class",if(j4<75,"First Class","Distinction")))))))))
Reply With QuoteReply With Quote