Microsoft Office Forums - View Single Post - [Solved] Formula for Complete/Incomplete

Thread: [Solved] Formula for Complete/Incomplete

View Single Post

Old

08-10-2016, 06:52 AM

Phil H

Phil H is offline

Phil H uses Windows XP

Windows XP Phil H uses Office 2010 64bit

Phil H uses Office 2010 64bit

Office 2010 64bit

Advanced Beginner

The original poster

Join Date: Jun 2010

Posts: 81

Phil H is on a distinguished road

Default

Partial Answer

This formula works for three cells. The range is 19 cells long, so how to condense this formula where all cells are included into one phrase?

=IF(H46="X","Incomplete",IF(I46="X","Incomplete",I F(J46="X","Incomplete","Complete")))

Reply With Quote