IF Fucntion Help!
 

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 Fucntion Help!
 

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

Change the resulting text to suit,
Regards,
Alan.
"Chabulo" wrote in message
...
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 Fucntion Help!
 

Thank you verry much alan!!