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
- English
- Switch per la lingua italiana
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
IMPORTANT!
Bets below the minimum in version 6
DOWNLOAD
the latest versions
of MarketFeeder Pro
of MarketFeeder Pro
MarketFeeder Pro is developed by WellDone Creative Software. ©2005-2010. All rights reserved. Terms and conditions.
© 2006 WellDone Creative Software

