IF Logical Test (2007)

Topic

New Reply

Is it possible to have something like this in an IF statement within a cell?

If((b29=”YES” AND H1=2), 1, 0)

I would like to test for two things and return a result.

Thanks,
Mark

Reply | Quote

Replies

In Excel, AND is a function just like if:

=IF(AND(B29=”YES”, H1=2), 1, 0)

Reply | Quote

I think there’s an echo in here.

Reply | Quote

Thanks Guys!

Reply | Quote

You were almost there! Try:

=IF(AND(B29=”YES”, H1=2), 1, 0)

Reply | Quote