Excel--Help!!

[new123]

In a Business report in which there are 4 stages (1,2,3,4) and each stages has a limit for example:
Stage 1 should only last 2 hours, Stage 2 should only last 4 hours, Stage 3 should only last 10 hours AND Stage 4 should only last 16 hours

SO according to the status reports IN EXCEL:
Stages/ Hours ---- Pass/Fail
3 / 9
2 / 3


4 / 10

So i have to get pass or fail from the report that I have. So take into account what STAGE it is and how much time it SHOULD TAKE(default time: Stage 1 should only last 2 hours, Stage 2 should only last 4 hours, Stage 3 should only last 10 hours AND Stage 4 should only last 16 hours) and how much time it TOOK. So if the hours in Excel exceeded the DEFAULT than fail, else Pass. But it has to compare the stages and hours one by one (I can program this but I can't think this through in Excel).

Please help me out, I know this is kinda CONFUSING. But any help will be appreciated.

[CGM3]

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"))

[Gary Drumm]

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

[Gary Drumm]

Actually that doesn't work either, cannot create a fail condition

[Gary Drumm]

This works (I moved everything down one row to allow for titles)
my E2=IF(B2>2,"fail","pass")
my E3=IF(B3>4,"fail","pass")
my E4=IF(B4>10,"fail","pass")
my E5=IF(B5>16,"fail","pass")