Thread: I am having problems with a IF(AND(OR nested function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debbie[_2_] Debbie[_2_] is offline
external usenet poster
  
Posts: 7
Default I am having problems with a IF(AND(OR nested function
it all works except for H6=6,I6=6,J6=6,K6=6,L6=6 in each if
statement. Sometimes these cells are blank; therefore, there is no
calculation, but it must calculate if a number =6 is in this cell

=IF(AND(M629.9,F6<19),32*5,IF(AND(M629.9,F6=19) ,
30*5,IF(AND(M6<30,F6<19,H6=6,I6=6,J6=6,K6=6,L6 =6),
39*S6,IF(AND(M6<30,F6<19,H6=6,I6=6,J6=6,K6=6),
39*S6,IF(AND(M6<30,H6<6,I6<6,J6<6,K6<6),26*S6,0))) ))

Can anyone help me figure this out. Thank you so much in advance!

Reply With QuoteReply With Quote