AND and OR Statements within an IF Statement.

[krowe111]

Good Day to All;
I am stuck on writing a formula. I currently have a formula that works but I need to make part of it an OR statement. I have not had any luck with this.

This is what part of my spreadsheet looks like:

Excel Help Picture.PNG
(I am trying to insert a .png, but I don't know if it will work.)

And here is my formula for Rowe 5, which checks to see if the Supervisor Training has been completed and that the first four numbers in D5 is >= 2015:
=IF(D5="?","Unknown",IF(AND(D5>=DATE(LEFT($I$2,4),4,1),ISBLANK(E5)),1,0))

This formula works great Row 5, but a Maintainer is considered Untrained until BOTH the Summer and Winter Maintenance Training has been completed.

So for Rows 6 and 7, in the second IF Statement I have to check that:

The first four numbers in D6 >= 2015
AND
F6 is blank
OR
G6 is blank

I cannot seem to get within an IF Statement, an AND Statement that combines an OR Statement.

I am stumped.

Any ideas?

[protonLeah]

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

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

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

[Graham Griggs]

You havnt downloaded your spreadsheet
But in general - columns are free ! use them
If you are trying to do b1 = a massive formula on a1 then do
b1 = or(xxx, xxx)
C1 = or (yyy,yyy)
D1 = and(b1,c1)

much easier to understand and debug and you can hide cols b and c if you dont need to see them in finished reult