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