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

[alchemy]

Have you used an IF formula?

[sheikah]

I haaaaaave and they keep failing no matter what I do. I'm just going to enter it manually and move on to the next problem - obviously this will take less time

[alchemy]

This person has basically answered your question, but I've got no idea if it will actually work.

[jenbug]

did you figure this out? I'm pretty good with Excel but I'm not 100% sure I understand what you're asking.

[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...