View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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!