If Cell contains "word" then assign value

[teckmann]

Basically I have several columns A-F.
Column A-F contains a list of words, some are blank
Column G is blank.
If a cell in column A contains a word like "academic", I want the number 1 to appear in the respective row in column G.
If a cell in column A does not contain a word "academic", I want the number 0 to appear in the respective row in column G.
Many thanks.

[easyexcelanswers]

it is a fairly straight forward formula
=IF(A1="academic", 1, 0)

ifacedemic.xlsx

[FDibbins]

Not quite so simple, what if B contains the word...or C?

tr this...
=if(countif(A1:F1,"academic")>0,1,0)