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

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

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

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

"mcmilja" wrote in message
...
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