Multiple (Nested) IF
 

Morning

I am trying to create a formula that look at a cell, checks that it is 80%
or over AND looks at three other cells to make sure they are NOT greater than
zero. The true statement should then be 'Meets Standard' and the false
statement 'Fails to Meet Standard'. Im struggling to make this work though.

This is what I have at the moment, the first IF statement works but the
second doesnt appear to.

=IF(M9=80%,IF('Assessment 1'!M72*'Assessment 2'!M72*'Assessment
3'!M720,"MEETS STANDARD","FAILED TO MEET STANDARD"))

Any ideas?

Thanks

Multiple (Nested) IF
 

I think you want something like:

=IF(AND(M9=0.80,'Assessment 1'!M72<=0,'Assessment
2'!M72<=0,'Assessment 3'!M72<=0),"MEETS STANDARD","FAILED TO MEET
STANDARD")

Hope this helps.

Pete

JaB wrote:

Morning

I am trying to create a formula that look at a cell, checks that it is 80%
or over AND looks at three other cells to make sure they are NOT greater than
zero. The true statement should then be 'Meets Standard' and the false
statement 'Fails to Meet Standard'. Im struggling to make this work though.

This is what I have at the moment, the first IF statement works but the
second doesnt appear to.

=IF(M9=80%,IF('Assessment 1'!M72*'Assessment 2'!M72*'Assessment
3'!M720,"MEETS STANDARD","FAILED TO MEET STANDARD"))

Any ideas?

Thanks