Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Logical Functions

 

=IF(AND(1A3, A3100), A3, The value is out of range )

Input the formula: =IF(AND(1<A3, A3<100), A3, "The value is out of range.")