Solved

Simple formule

Posted on 2011-09-27
5
275 Views
Last Modified: 2012-05-12
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
Comment
Question by:kensy11
  • 2
  • 2
5 Comments
 
LVL 50

Expert Comment

by:barry houdini
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

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

Accepted Solution

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

by:HainKurt
HainKurt earned 250 total points
ID: 36712244
use

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

Author Comment

by:kensy11
ID: 36712333
ahan thank you
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

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…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now