use of OR in a formula (not as in and/or type meaning)

[rmccafferty]

I am faced with an extremely complex workbook with formulas that contain code I have not used or seen before. If anyone can explain what OR means in the following, I would be very grateful. I do not see how the OR could mean literally, or, and it does not refer to a worksheet column of OR:

'=INT(0.5+RC[1]/12)+IF(OR(Input!R[16]C="A", Input!R[16]C="SA", Input!R[16]C="Q", Input!R[16]C="BM"),0.001,0)+IF(OR(Input!R[16]C[2]="C",Input!R[16]C[2]="BC",Input!R[16]C[2]="RC"),0.002,0)+IF(OR(Input!R[16]C[2]="B",Input!R[16]C[2]="BC",Input!R[16]C[2]="BRET"),0.004,0)+IF(OR(Input!R[16]C[2]="R",Input!R[16]C[2]="RC",Input!R[16]C[2]="RRET"),0.008,0)

The above is all one line in the Excel cell, but for whatever reason did a couple of line breaks when I pasted it above. I added the leading apostrophe in the first line. There are innumerable cells within many tabs of this workbook with these designations in them.

 

[T. Valko]

I am faced with an extremely complex workbook with formulas that contain code I have not used or seen before. If anyone can explain what OR means in the following, I would be very grateful. I do not see how the OR could mean literally, or, and it does not refer to a worksheet column of OR:

'=INT(0.5+RC[1]/12)+IF(OR(Input!R[16]C="A", Input!R[16]C="SA", Input!R[16]C="Q", Input!R[16]C="BM"),0.001,0)+IF(OR(Input!R[16]C[2]="C",Input!R[16]C[2]="BC",Input!R[16]C[2]="RC"),0.002,0)+IF(OR(Input!R[16]C[2]="B",Input!R[16]C[2]="BC",Input!R[16]C[2]="BRET"),0.004,0)+IF(OR(Input!R[16]C[2]="R",Input!R[16]C[2]="RC",Input!R[16]C[2]="RRET"),0.008,0)

The above is all one line in the Excel cell, but for whatever reason did a couple of line breaks when I pasted it above. I added the leading apostrophe in the first line. There are innumerable cells within many tabs of this workbook with these designations in them.

The OR does mean literally or.

The formula is using R1C1 references.

IF(OR(Input!R[16]C="A", Input!R[16]C="SA", Input!R[16]C="Q", Input!R[16]C="BM"),

Which means:

IF OR cell reference ="A", OR cell reference ="SA", OR cell reference ="Q", OR cell reference ="BM".

 

[Herbert Seidenberg]

Excel 2010
Here are two ways to re-formulate the formula
without using the function OR()
or the R[]C[]/RC reference
or the $A$1/A1 reference
and make it more readable.
http://c3017412.r12.cf0.rackcdn.com/04_25_11.xlsx
If you get *.zip, don't unzip, just rename *.xlsx