how compear two or more values into the same function
 

i need check two or more "values"getting into the same cell but into the same
function someting like this example
IF (R20=30 or 20 or 10),"true", "false"

how compear two or more values into the same function
 

Maybe

=IF(OR(R20=10,R20=20,R20=30),TRUE,FALSE)

Mike

"Fabian" wrote:

i need check two or more "values"getting into the same cell but into the same
function someting like this example
IF (R20=30 or 20 or 10),"true", "false"

how compear two or more values into the same function
 

Even shorter:

=OR(R20={10,20,30})

"Mike H" wrote:

Maybe

=IF(OR(R20=10,R20=20,R20=30),TRUE,FALSE)

Mike

"Fabian" wrote:

i need check two or more "values"getting into the same cell but into the same
function someting like this example
IF (R20=30 or 20 or 10),"true", "false"

how compear two or more values into the same function
 

One option is =IF(OR(R20=30,R20=20,R20=10),"true","false")
Note that if you want the true and false to be the boolean values, rather
than text, you'll need to leave out the quote marks.
--
David Biddulph

"Fabian" wrote in message
...
i need check two or more "values"getting into the same cell but into the
same
function someting like this example
IF (R20=30 or 20 or 10),"true", "false"