If statement to output specific text if 2 criteria are met?

M

mcmilja

Hello,

What If statement can I use to output specific text if 2 criteria are met?
For example if cell B2 and C2 contains text "spare" then D2 outputs "spare"

Thanks.
Jaret
 
D

David Biddulph

=IF(AND(B2="spare",C2="spare"),"spare","whatever you want in the alternative
condition")
 
Top