Previous Topic Next Topic

Greater than and less than

Closed
slim - Oct 1, 2015 at 09:14 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Oct 1, 2015 at 10:03 PM
Hello, i need help.

A4 is the input
i need to make it so that if A4 is greater than 1 and less than 100 it will display "centimeters" . Any suggestions??



1 response

Answer 1 / 1
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Oct 1, 2015 at 10:03 PM
You cannot put the result, "Centimeters", in the same cell as the source.
The formula must go in another cell.

Either of these will do what you want: 
=IF(AND(A4>1,A4<100),"Centimeters","")
=IF(A4>1,IF(A4<100,"Centimeters",""),"")


The "" can be replaced with another value if the criteria is not met.
e.g.
=IF(AND(A4>1,A4<100),"Centimeters","NOT Centimeters")
or
=IF(A4>1,IF(A4<100,"Centimeters",">100"),"<1")