how do i get MS excel to look at one column, and if it contains the text "2007" in the cell, then on a separate cell, put "false"
how do i do this?
2007-12-27 05:55:00 · 3 answers · asked by Anonymous in Computers & Internet ➔ Software
if any cells in column A contains plain text 2007, then will return "false"
=IF(A:A="2007",FALSE,"")
if any cells in column A contains number/value 2007, then will return "false"
=IF(A:A=2007,FALSE,"")
if cell A1 contains number/value 2007, then will return "false"
=IF(A1=2007,FALSE,"")
2007-12-30 02:32:31 · answer #1 · answered by MYs 5 · 2⤊ 0⤋
A1 = 2007
B1 = IF(A1=2007, False)
2007-12-27 06:02:43 · answer #2 · answered by Icon 7 · 1⤊ 0⤋
icon forgot the 2nd comma
copy and paste this down column B
=IF(A1=2007,FALSE,"")
2007-12-28 13:54:53 · answer #3 · answered by expletive_xom 7 · 0⤊ 0⤋