Link to home
Start Free TrialLog in
Avatar of Dier02
Dier02Flag for Australia

asked on

less than but greater than

What is the formula for a cell which states'= less than 12 but greater than 3'?
ASKER CERTIFIED SOLUTION
Avatar of jppinto
jppinto
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
typo! Should be like this:

=IF(AND(A1<12,A1>3),"True","False")
Example attached...
IF.xlsx
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Dier02

ASKER

Thanks guys