MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Need help with simple formula

Posted by KD on September 30, 2000 11:51 AM

If I have a group of numbers in a table, how do I construct an if
statement to detect whether a specific number appears in that table.

For example (my table)

1 2 3
4 5 7
8 9 10

I want to know if the number 5 appears in that 3x3 table, whats the


I assume its something like this, but I dont know what goes in the

please help, thanks in advance

Posted by Ivan Moala on September 30, 2000 4:48 PM

Try; =IF(COUNTIF(A1:C3,"=5")>0,"True","False")