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
formula?

=if(????(A1:c3)=5,1,0)

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")

Ivan