Microsoft Office Forums - View Single Post - [Solved] Excel--Help!!

Thread: [Solved] Excel--Help!!

View Single Post

Old

09-04-2013, 05:50 AM

Gary Drumm Gary Drumm is offline

Gary Drumm is offline

Gary Drumm uses Windows XP

Windows XP Gary Drumm uses Office 2007

Gary Drumm uses Office 2007

Office 2007

Advanced Beginner

Join Date: Mar 2012

Posts: 86

Gary Drumm is on a distinguished road

Default

=IF(A1 = "", "", IF(B1 > CHOOSE(2,4,10,16), "Fail", "Pass"))
A slight modification to CGM3's post, works for me.
HTH

Reply With Quote