Comparison Formula

[yolie.jimenez]

Hi there!

Need help with a formula that will solve the problem below:


if b17 is LESS than 30 and c17 is GREATER than 84 or b17 is LESS than
30 and c17 is greater than 85 but less than 108, "true", "false"


Please help! I just about pulled out my last hair!

Thanks!

 

[Biff]

Hi!

I just about pulled out my last hair!

Well, at least you have some left!

=IF(AND(B17<30,C17>85,C17<108),"True",IF(AND(B17<30,C17>84),"True","False"))

Biff

 

[yolie.jimenez]

Thank you! You've saved my last hair!

 

[Biff]

You're welcome!

Biff