Is it possible to have an "AND" condition in an "If Then" statement?
For example, how would you write "if cell A1 and C1 and E1 all equal "x",
then return "yes". If not, return "no".
Is it possible to have an "AND" condition in an "If Then" statement?
For example, how would you write "if cell A1 and C1 and E1 all equal "x",
then return "yes". If not, return "no".
Try this:
=IF(AND(A1=10,A2=10,A3=10),"Yes","No")
On Tue, 22 Feb 2005 08:41:03 -0800, "alm09"
<[email protected]> wrote:
>Is it possible to have an "AND" condition in an "If Then" statement?
>
> For example, how would you write "if cell A1 and C1 and E1 all equal "x",
>then return "yes". If not, return "no".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks