LogFAQs > #812716

LurkerFAQs ( 06.29.2011-09.11.2012 ), Active DB, DB1, DB2, DB3, DB4, DB5, DB6, DB7, DB8, DB9, DB10, DB11, DB12, Clear
Topic List
Page List: 1
TopicCan someone super knowledgeable on Excel functions help me out?
baron von toast
02/19/12 1:29:00 AM
#2:


So the correct word is a cell, and you're checking each of the 20 entries to see if they match that word? I think a regular IF formula works, yes?

=IF(A1=B1,truenumber, falsenumer)
where A1is the test word cell and B1 is the correct cell.

--
.
... Copied to Clipboard!
Topic List
Page List: 1