IF(OR) Statement not giving results

Hi guys, i am new to this thread, hopefully can get some help from here.

i have an excel file that contains 2000 records.

so lets say year 1- 2 they have a score of 1, and year 3-4 score of 2 and year 5-6 score of 3, year 7-8 score of 4 and lastly, year 9-11 score of 5

N2 is year 11, M2 is year 10 and L2 is year 9.

in my excel spreadsheet. D2 is year 1, E2 is year 2. F2 is year 3, G2 is year 4, H2 is year 5, I2 is year 6, J2 is year 7, K2 is year 8.

so using this excel code; =IF(OR(N2>=5,M2>=5,L2>=5),5,0) --> Using this code i got a score of 5, but when i continue to input any value codes it gives me an error #value. The thing is not every record will get a score of 5. some will get 4 points and some will get 3 points.

So, how do i continue the codes using (IF(OR)??

Originally Posted by LaoDa

Hi, i tried your way and this way. Still cant work.

You need to post a workbook so we don't keep guessing at what we are working with:

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

M2=IF(COUNTIF(J2:L2,">=5"),5,0)
try this if it is not you are looking for give expected result