Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement that outputs specific text if cell is not null | Excel Discussion (Misc queries) | |||
How to output text that blinks? | Excel Discussion (Misc queries) | |||
Count items when specific text and date criteria are met | Excel Worksheet Functions | |||
add text to end of formula output | Excel Discussion (Misc queries) | |||
Referencing cells text output if it meets specific conditions | Excel Worksheet Functions |