I cannot be this stupid.

[sheikah]

There is a way to do a formula in Excel where like, if one cell equals a certain word, it puts a number in the cell you put the formula in?

NOTHING I HAVE TRIED HAS WORKED.

Comments

[nozenfordaddy]

Try =IF(cell with word=word, number if true, number if false)

So like:

=IF(A1=TRUE, 1, 0)

If that doesn't work, or your word is more complex, you may need to put "quotations" so it would be:

=IF(A1="Answer positive", 1, 0)

Unless you've already tried that in which case I've no idea why it didn't work...