View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jonssmaster jonssmaster is offline
external usenet poster
 
Posts: 13
Default Complex If/And Statement

I'm stuck! I can't find a way to get this complex formula to work. First,
where am I going wrong? And second, is there an easier way to write it? I'm
guessing I have too many arguements. HELP!

=IF(AND(G8=0,H8=0%),"Successful",IF(AND(G8=1,H8= 30%),"Successful",IF(AND(G8=2,H8=40%),"Successful ",IF(AND(G8=3,H8=50%),"Successful",IF(AND(G8=4,H8 =65%),"Successful",IF(AND(G8=5,H8=75%),"Successf ul",IF(AND(G8=6,H8=90%),"Successful",IF(AND(g8=6 ,h8<=80%),"DoesNotMeet",IF(AND(G8=6,<=89%,"Incons istent",IF(AND(G8=6,H8<=114%"Successful",IF(AND(G 8=6,H8<=124%,"Excellent",IF(AND(G8=6,H8=125%,"E xceptional"))))))))))))