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

# 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
• 2
• 2
2 Solutions

Commented:
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

Author Commented:
and what if i want some other text instead of true and fals
0

Commented:
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

Sr. System AnalystCommented:
use

=if(AND(A2>A3,A2<A4),"greater","smaller")
0

Author 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.