Complex IF/AND/OR/THEN Statement

I need help solving a complex IF/AND/OR/THEN statement.
Cell Legend
A3 = total # of product deliveries
B3 = current # of products received
C3 = due date for total # deliveries (100, or cell A3)
D3 = Project status

In this situation, I am trying to solve D3, the project status (“On time,” “In work,” “Risk,” or “Late) based on the # of products received in relation to the due date. Below are the statements I am trying to make in a single formula, but am having a hard time with the syntax.
1. If today’s date is later than the due date and the # received products is fewer than the total # of deliveries, then the status should indicate “Late”
IF TODAY()>C3, AND B3<A3, “Late”

2. If today’s date is earlier than the due date and the # received products is fewer than the total # of deliveries, then the status should indicate “In Work”
IF TODAY()<C3, AND B3<A3, “InWork”

3. If today’s date is greater than 2 weeks before the due date, or is equal to the due date and the # received products is fewer than the total # of deliveries, then the status should indicate “Risk”
IF TODAY()>C3-14 OR TODAY()=C3, AND B3<A3, “Risk”

4. If today’s date is earlier or equal to the due date and the # received products is greater than or equal to the total # of deliveries, then the status should indicate “On Time”
IF TODAY()>C3, AND B3<A3, “On Time”

A B C D
1 Project
2 # Deliveries # Received Due Date Status
3 100 50 3/1/2019 ?


I have spent so much time on figuring this out that my brain hurts :/
Any help is appreciated!!

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.