• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • 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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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