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-29-2016, 12:54 AM

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

=IF(B10<1,"",IF(E10>1,"Closed","Open")) worked it out but thanks for all your help

Reply With Quote