Excel AND Function
See more:
- Excel Tips
- Excel Cell References
- Cell Addressing
- Text and Values in One Cell
- How To Use Excel IF Function
- Functions
- How to Determine whether VBA is Enabled
- Adjusting formulas to your Regional Settings
- Excel AND Function
- Excel Date and Time Format
In Excel, the And function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.
The syntax for the And function is:
And( condition1, condition2, ... )
condition is something that you want to test that can either be TRUE or FALSE. There can be up to 30 conditions.
For example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=And(A1>10, A1<40) would return TRUE =And(A1=30, A2="Microsoft") would return FALSE =And(A1>=5, A1<=30, A2="Tech on the Net") would return TRUE
TRY for FREE
we do not sell
a pig in a poke
a pig in a poke
HELP FILE
a complete description
of the software in PDF
of the software in PDF
TRIGGERS
download ready-to-go solutions
FORUM
communicate with traders
like you
like you
DOWNLOAD
the latest version is
5.2.0.5 from 05-06-2009
5.2.0.5 from 05-06-2009
VIDEO LESSON
How to test staking plans without risking your money
MarketFeeder Pro is developed by WellDone Creative Software. ©2005-2009. All rights reserved. Terms and conditions.
© 2006 WellDone Creative Software