IF Fucntion Help!

  • Thread starter Thread starter Chabulo
  • Start date Start date
C

Chabulo

Hi all I Have "8.4" entered in cell B2. Now, i want to create an IF function
in B3 that needs to check that B2 is between 7.2 and 7.8, thus, including 7.2
and 7.8. How do I do this??

Thanks in advance for your help
 
=IF(AND(B2>=7.2,B2<=7.8),"Within Limits","Not between Limits")

Change the resulting text to suit,
Regards,
Alan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight intersection in a table using conditional formatting 2
Compare 2 Fields 1
Referencing a cell even if its contents are moved moved/replaced 6
Convert currency within column 1
Conversion from decimal value to time. 3
Array Sort and/or Index problem 1
nesting if formula 8
Need help with if-then statement in formula 6

Back
Top