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')

Similar Questions

People Also Asked

Top Related Searches

Wikipedia on Ask.com

Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables,...