Only pass if two conditions met 1

[SnapperHG1]

Hi folks,

I've tried searching all the forums, etc based upon multiple If statements, and I'm damn sure this is a no brainer but I can't seem to crack it!

If a value is less than span/360 *and* less than 12mm, pass. If not fail.

I seem to be struggling with the AND part.

Help would be really, really appreciated.

Steve

 

[GlennUK]

You can do it with one IF, by using the AND function.

=IF(AND(A1<(span/360),A1<12),"Pass","Fail")

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SnapperHG1]

Thankyou so much! Had tried AND from another forum on Eng-Tips I think, but it had AND and If the other way around!

1st week in a new job, so double thanks