Including 2 conditions in an IF function

[Guest]

I'm trying to include two conditions in an IF funtion. For example: If cell
C4=20 AND cell D4=10, print cell E4. Would be grateful if anyone has any
ideas. Cheers, Tom

 

[RNR]

Try this "IF(C4=20,IF(D4=10,E4,0),0)"

 

[Bob Phillips]

or

=IF(AND(C4=20,D4=10,E4,0))

--

HTH

RP

Try this "IF(C4=20,IF(D4=10,E4,0),0)"

 

[Guest]

Thanks, both very useful ideas.
Tom

 

[Paul Cunliffe]

Try =IF(AND(C4=20,D4=10),"Action if true","Action if false")

Paul