Solved

# Simple formule

Posted on 2011-09-27
275 Views
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
Question by:kensy11
• 2
• 2

LVL 50

Expert Comment

ID: 36711961
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 Comment

ID: 36712135
and what if i want some other text instead of true and fals
0

LVL 50

Accepted Solution

barry houdini earned 250 total points
ID: 36712238
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

LVL 51

Assisted Solution

HainKurt earned 250 total points
ID: 36712244
use

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

Author Comment

ID: 36712333
ahan thank you
0

## Featured Post

### Suggested Solutions

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…