Thread: [Solved] Excel--Help!!
View Single Post
 
Old 08-28-2013, 07:15 AM
CGM3 CGM3 is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: Oct 2009
Posts: 38
CGM3 is on a distinguished road
Default
A quick and dirty solution, here assuming the stage number is in Column A and its hours are in Column B, then place in Column C for each row i:

=IF(Ai = "", "", IF(Bi > CHOOSE(Ai,2,4,10,16), "Fail", "Pass"))
Reply With Quote