Excel 2007 : Evaluating multi logical expressions in Excel

**StaffanC** · 02-12-2009, 07:52 AM

Hi everyone,

Is it somehow possible to use logic like the below in Excel?

If (A1 = -1) AND (C3 <> 5) AND (C8>4) Then...

I need to evaluate at least two logical expressions before making the descision as to what value to assign to a certain cell.

Looking forward to your answer,

Regards,

Staffan Carlsson

**DonkeyOte** · 02-12-2009, 08:15 AM

Yes...

IF(AND(condition1,condition2),do if all true, do if any false)

You also have

IF(OR(condition1,condition2),do if ANY true, do if ALL false)

And obviously you can combine

IF(AND(condition1,OR(condition2,condition3)),do if ALL true, do if ANY false)