Formulas

[casman]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Can anyone tell me how to use multiple logic tests within a formula? I'd like to use three logic tests, all of which will need to be true to use "value if true".

 

[macropod]

Hi Casman,

In essence, you can do something like:
=(A1=1)*(B1=10)*(C1=100)*D1
or
=IF((A1=1)*(B1=10)*(C1=100)=1,D1,"")

What these two formulae do is to compare the contents of cells A1, B1 & C1 against some value (you could use other cell
references/formulae instead) and, if all three cells match their reference values, outputs the value in D1 (ie the "value if true").
The first form works with numeric data in D1; the second form works with alpha data as well.

 

[CyberTaz]

I addition to macropod's suggestions you can nest the AND() function in the
IF() statement's condition, such as:

=IF(AND(A1=5,B1>10,C1<6),ValueIfTrue,ValueIfFalse)

Explore Logical Functions in Excel Help through the Formula Builder.

HTH |:>)
Bob Jones
[MVP] Office:Mac