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

Simple formule

Hello,

im starting to learn MS excel , and i like to do the following.

this is my table , and i like to get True massege if A2>A3 and A2<A4 is true, and a False message if its not.
how can i do this, i can do it for just one, i dont knwo how i can get an AND in between of an IF formule

      A
1      De data
2      15
3      9
4      8


Thank you
0
kensy11
Asked:
kensy11
  • 2
  • 2
2 Solutions
 
barry houdiniCommented:
You can use AND like this

=AND(A2>A3,A2<A4)

that will only give you TRUE if both statements are TRUE

regards, barry
0
 
kensy11Author Commented:
and what if i want some other text instead of true and fals
0
 
barry houdiniCommented:
You can use any statement that returns TRUE or FALSE in an IF statement so if you want "Yes" or "No", for instance use the above in an IF

=IF(AND(A2>A3,A2<A4),"Yes","No")

regards, barry
0
 
HainKurtSr. System AnalystCommented:
use

=if(AND(A2>A3,A2<A4),"greater","smaller")
0
 
kensy11Author Commented:
ahan thank you
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: 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.

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