Microsoft Office Forums - View Single Post - [Solved] If/AND/OR Formula for 3 way solution

Thread: [Solved] If/AND/OR Formula for 3 way solution

View Single Post

Old

06-27-2016, 11:40 PM

Skye123456 Skye123456 is offline

Skye123456 is offline

Skye123456 uses Windows XP

Windows XP Skye123456 uses Office 2013

Skye123456 uses Office 2013

Office 2013

Novice

The original poster

Join Date: Jun 2016

Posts: 5

Skye123456 is on a distinguished road

Default

Yes sorry if E2 is blank.

Your formula half works, but when B2 is blank (no date) D2 says closed instead it should be blank too.

I really appreciate your help though.

Reply With Quote