=IF(OR(A1:B7=5),TRUE,FALSE)
ctrl+shift+enter (not just enter)
"coloradoprof" wrote:
Hi everyone,
I'm trying to create a tool that can help me with Sudoku (I'm getting
bored of charting the possible values of a given cell).
To do this, I must find out whether a given value (for example 3)
exists in a specified range. I can't find a function that does this
for me.
In my perfect world, it would work something like this:
=if((A1:A5,B3:B7) in 5, true, false)
All ideas appreciated. :)
--
coloradoprof
------------------------------------------------------------------------
coloradoprof's Profile: http://www.officehelp.in/member.php?userid=5258
View this thread: http://www.officehelp.in/showthread.php?t=1270123
Posted from - http://www.officehelp.in