Home |
Search |
Today's Posts |
#1
|
|||
|
|||
OR Operator
I would like to inspect the value of Column C for many rows of a worksheet.
If column C's value does not equal 5506, 6879 or 7553, then Column C's value should be displayed in Column D. If it does equal 5506, 6879 or 7553, then Column D should display nothing. Column D's formula should be something like: =IFC1<{5506,6879,7553},C1,"") But this does not work, as only 5506 gets evaluated. How do I get the other numbers to be included in the comparison? Is an OR operator required i.e. 5506 OR 6879 OR 7553 Thanks in advance for any assistance. |
#2
|
|||
|
|||
Hi Freddy
=IF(OR(C1=5506,C1=6879,C1=7553),"",C1) -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Freddy" wrote in message ... I would like to inspect the value of Column C for many rows of a worksheet. If column C's value does not equal 5506, 6879 or 7553, then Column C's value should be displayed in Column D. If it does equal 5506, 6879 or 7553, then Column D should display nothing. Column D's formula should be something like: =IFC1<{5506,6879,7553},C1,"") But this does not work, as only 5506 gets evaluated. How do I get the other numbers to be included in the comparison? Is an OR operator required i.e. 5506 OR 6879 OR 7553 Thanks in advance for any assistance. |
#3
|
|||
|
|||
=IF(OR(C1={5506,6879,7553}),C1,"")
-- HTH RP (remove nothere from the email address if mailing direct) "Freddy" wrote in message ... I would like to inspect the value of Column C for many rows of a worksheet. If column C's value does not equal 5506, 6879 or 7553, then Column C's value should be displayed in Column D. If it does equal 5506, 6879 or 7553, then Column D should display nothing. Column D's formula should be something like: =IFC1<{5506,6879,7553},C1,"") But this does not work, as only 5506 gets evaluated. How do I get the other numbers to be included in the comparison? Is an OR operator required i.e. 5506 OR 6879 OR 7553 Thanks in advance for any assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BIMDAS - Order of Calculation | Excel Discussion (Misc queries) | |||
"--" operator in a formula | Excel Worksheet Functions | |||
Analyzing non numerical data in an excel spread sheet | Excel Worksheet Functions | |||
hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION | Excel Worksheet Functions | |||
How to Concatenate Time with some operator? | Excel Worksheet Functions |