Thread: Excel Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
~slacker~ ~slacker~ is offline
external usenet poster
  
Posts: 7
Default Excel Formula
is this what you are looking for/

=IF(AND(A1<=3000,B1<=10,C1<=5),"Class
I",IF(AND(A13000,A1<=10000,B110,B1<=12,C15,C1<= 10),"Class
II",IF(AND(A110000,B112,C110),"Class III","")))
Reply With QuoteReply With Quote