khalid79m
03-24-2009, 05:06 AM
=IF(Final_Check="Incomplete","Data Missing - Please Check!",IF(Final_Check<>"Complete","0",IF(OR(I3=1,I3=2),IF(OR(Question_06_OV="N",Question_07_OV="N"),0,SUM(Calc_Q1_OV+Calc_Q2_OV+Calc_Q3_OV+Calc_Q4_OV+Calc_Q5_OV)))))
My formula is above,
I need it to also if I3=3 then sum Q1_NV , Q2_NV UPTO Q7_NV, but if I3 =3 THEN no need to check if Question_06_OV="N",Question_07_OV="N"),
if that makes sense
My formula is above,
I need it to also if I3=3 then sum Q1_NV , Q2_NV UPTO Q7_NV, but if I3 =3 THEN no need to check if Question_06_OV="N",Question_07_OV="N"),
if that makes sense