Previous Topic Next Topic

Greater than and less than

Closed
slim - 1 Oct 2015 à 21:14
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 1 Oct 2015 à 22:03
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

Réponse 1 / 1
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 26
1 Oct 2015 à 22:03
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")