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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
If statement that outputs specific text if cell is not null 2
Cumulative formula for word table 0
Need help with If statement 3
Alternative for Vlookup output of #N/A if data not found? 4
Finding the right style field in VBA 0
Page numbering with Merged Document and IF statements 1
If function..please help 1

Top