Help with creating a IF statement

I am a novice at best in excel and need some help. I am trying to make a if statement that references a specific cell on another sheet in a workbook so that if that cell has "Estimate" typed into it ...