D
Debbie
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(M6>29.9,F6<19),32*5,IF(AND(M6>29.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!
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(M6>29.9,F6<19),32*5,IF(AND(M6>29.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!