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!
|