• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 580
  • Last Modified:

less than but greater than

What is the formula for a cell which states'= less than 12 but greater than 3'?
0
Dier02
Asked:
Dier02
4 Solutions
 
jppintoCommented:
=IF(AND(A1<12;A1>3),"True","False")
0
 
patrickabCommented:
Perhaps like this:

=If(and(A1<=12,A1>=3),"Found one","Not this one")
0
 
jppintoCommented:
typo! Should be like this:

=IF(AND(A1<12,A1>3),"True","False")
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
jppintoCommented:
Example attached...
IF.xlsx
0
 
MINDSUPERBCommented:
Or you might be only testing True or False:

=AND(A1<12,A1>3)
0
 
jppintoCommented:
Any news?
0
 
Dier02Author Commented:
Thanks guys
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now