How do you enter a "greater than but less than" expression in Microsoft Excel?


Let's say that you need your formula to return a value in C2 where A2-B2 is greater than 20 but less than 50. You could use =If(AND(A2-B2>20=TRUE,A2-B2<50=TRUE), C2, 'FALSE')
About -  Privacy -  Careers -  Ask Blog -  Mobile -  Help -  Feedback  -  Sitemap  © 2015