Nested If Statement with errors

[ypurcaro]

IfStatement.xlsIfStatement.xls
Hi Folks,

How are you? I have attached a spreadsheet so you can see what I'm talking about.

Basically, the column I and M cannot be 0 and the V column needs to be at least 8. Then, column W will return a result "qualified".

Here is my formula:
=IF(I2:I6>0, IF(M2:M6>0), IF(V2:V6>8),"Qualified"," ")))

Please tell me what is wrong with this formula. I appreciate your help.

ypurcaro

[FDibbins]

you were almost there. with this type of IF statement, you only use a single cell, not a range...
=IF(I2>0,IF(M2>0,IF(V2>8,"Qualified"," ")))

But this can be further simplified to...
=IF(AND(I2>0,M2>0,V2>8),"Qualified"," ")

[ypurcaro]

Thank you very much! It works just fine now!

you were almost there. with this type of IF statement, you only use a single cell, not a range...
=IF(I2>0,IF(M2>0,IF(V2>8,"Qualified"," ")))

But this can be further simplified to...
=IF(AND(I2>0,M2>0,V2>8),"Qualified"," ")

[FDibbins]

Happy to help and thanks for the feedback