PDA

View Full Version : Solved: If statements



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

Bob Phillips
03-24-2009, 05:15 AM
Try

=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,
Calc_Q1_OV+Calc_Q2_OV+Calc_Q3_OV+Calc_Q4_OV+Calc_Q5_OV),
IF(I3=3,Q1_NV+Q2_NV+Q3_NV+Q4_NV+Q5_NV+Q6_NV+Q7_NV))
)
)

khalid79m
04-16-2009, 03:27 AM
thanks :)

Bob Phillips
04-16-2009, 03:44 AM
Housekeeping day?:)