| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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" |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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" |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The IF function but with 3 values | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Multiple If function for more than 7 values | Excel Worksheet Functions | |||
| Function to add different values | Excel Worksheet Functions | |||
| look up function and sum values | Excel Worksheet Functions | |||
Linear Mode
