IF or OR function

[cell-dweller]

Hi
I have a sheet where i need to check 2 cells for details. Th first check is to see if the job is late (ie due date less 2 or 3 days) and the other check is whether the job has been completed.
Not sure what function to use. I need to see if it meets the criteria in both and then return a value. I think checking to see if it is completed first is the most important, then to chck if it is late.
I have attached an example.

Thanks

[DonkeyOte]

I think checking to see if it is completed first is the most important, then to chck if it is late.

Agreed - always order your IF arguments by order of precedence given an IF will exit upon first TRUE.

Consider: A1 is 10

=IF(A1>5,"a",IF(A1>8,"b","c"))

the answer would always be "a" given 10 > 5 though we want "b" that test is never actioned, so:

=IF(A1>8,"b",IF(A1>5,"a","c"))

would return "b" correctly - were we to change A1 to 7 we would get "a", to 4 we would get "c"

Adjusting your formula along similar lines:

=IF(D3>1,"COMPLETE",IF(A3<($B$1-2),"JOB LATE",""))

[cell-dweller]

Thank You DonkeyOte. That makes sense and the formula work for me. I have one other question though, I need to to fill this formula down and have done conditional formatting to make the "Job Late" stick out.
Is there a way to hide any remarks until the first date cell has data put in? Otherwise I have a spreadsheet with many lines down of "Job late" in bright red!

[The Phil]

Thank You DonkeyOte. That makes sense and the formula work for me. I have one other question though, I need to to fill this formula down and have done conditional formatting to make the "Job Late" stick out.
Is there a way to hide any remarks until the first date cell has data put in? Otherwise I have a spreadsheet with many lines down of "Job late" in bright red!

Start it with =IF(A10="","",......)

I use A10 to represent the first date, didn't look at your sheet, and the "..." is your current formula.

[cell-dweller]

Thank you.

This works very nicely.