IF Fucntion Help!

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
 
A

Alan

=IF(AND(B2>=7.2,B2<=7.8),"Within Limits","Not between Limits")

Change the resulting text to suit,
Regards,
Alan.
 
Top