Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

if function

ResolvedVersion 2016

Mark has attended:
Excel Advanced course

IF Function

I am trying to create a formula using the following criteria:

Before today's date AND has a status of either Draft Report, Final Report, Cancelled, Closed.

I have been trying to use the following formula and it hasn't worked:
=IF(AND(F2<=$AG$1,OR(P2<>"Final Report Issued",P2<>"Draft Report Issued",P2<>"Audit Closed",P2<>"Audit Cancelled")),"At Risk","Completed")

AG1 has the date function applied to it.

At the moment it is giving me the wrong outcomes on the cells that don't meet the above criteria.

Please help.

Thanks,
Mark

RE: IF Function

Hi Mark,

Thank you for the forum question.

Change the or function to:

OR(P2="Final Report Issued",P2="Draft Report Issued",P2="Audit Closed",P2="Audit Cancelled")


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Sun 8 Dec 2019: Automatically marked as resolved.

Excel tip:

How to Spell Check an Excel 2010 Worksheet

Excel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet.

Either select the ''Review'' tab in the Ribbon, go to the ''Proofing'' section and click ''Spelling.'' Or, simply press F7.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.