Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 09-04-2013, 05:50 AM
Gary Drumm Gary Drumm is offline Excel--Help!! Windows XP Excel--Help!! 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel--Help!! [Excel 2007] Building Power Point Slides from data in an Excel Table bremen22 Excel Programming 1 08-07-2013 11:01 AM
Paste special an Excel range into Outlook as an Excel Worksheet charlesh3 Excel Programming 3 02-04-2013 04:33 PM
Excel--Help!! Excel 2011 can't open old Excel 98 or Excel X files FLJohnson Excel 8 05-09-2012 11:26 PM
Excel 2007 custom ribbon not showing in Excel 2010 Paulzak Excel 2 02-17-2012 06:35 PM
Excel--Help!! saving data in excel 2010 from excel 2003 johnkcalg Excel 1 02-06-2012 07:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft