Comparison Formula
 

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!

Comparison Formula
 

Hi!

I just about pulled out my last hair!

Well, at least you have some left!

=IF(AND(B17<30,C1785,C17<108),"True",IF(AND(B17<3 0,C1784),"True","False"))

Biff


wrote in message
oups.com...
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!

Comparison Formula
 

Thank you! You've saved my last hair!

Comparison Formula
 

You're welcome!

Biff

wrote in message
oups.com...
Thank you! You've saved my last hair!