View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mcmilja mcmilja is offline
external usenet poster
 
Posts: 35
Default 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