I am trying to compare 2 columns of time. Here is the formula I am
trying to use:

=IF(H2>(LOOKUP(Sheet3!A2,Minimums!A2:A35,Minimums!D235)),
"Pass","Fail")

H2 is the run time (mm:ss), A2 is their age, A2:A35 and D235 is ages
and max times.

Basically, I look at someone age, then take the time it took them to
run 3 miles and compare that time to a maximum standard time for the
same age.
Example: 22 year old male has 28 minutes to run 3 miles.

I want to have the cell tell me if the run time is greater than the max
allowed time.


Any help will this is greatly appreciated. Thanks.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

It looks like you've got your "Pass" & "Fail" inverted (based on my
understanding of your logic). But other than that, your formula looks good.
Is there something amiss in the results?

Are your ages sorted (ascending) on the Minimums sheet?

/i.

"TARogers" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> I am trying to compare 2 columns of time. Here is the formula I am
> trying to use:
>
> =IF(H2>(LOOKUP(Sheet3!A2,Minimums!A2:A35,Minimums!D235)),
> "Pass","Fail")
>
> H2 is the run time (mm:ss), A2 is their age, A2:A35 and D235 is ages
> and max times.
>
> Basically, I look at someone age, then take the time it took them to
> run 3 miles and compare that time to a maximum standard time for the
> same age.
> Example: 22 year old male has 28 minutes to run 3 miles.
>
> I want to have the cell tell me if the run time is greater than the max
> allowed time.
>
>
> Any help will this is greatly appreciated. Thanks.
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>

immanuel,

Yes the result does not change once the time goes belong the ma
allowed time (i.e., the result says "Pass" for a 22:15 time, but still
says "Pass" for a 29:26 time). I tried changing the inequalities an
text result ("Pass" or "Fail"), but have not had any success. You
help is greatly appreciated.

Tod

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Hi Todd,

Would you like to post a sample of your real data? It might help me help
you more efficiently.

/i.

"TARogers" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> immanuel,
>
> Yes the result does not change once the time goes belong the max
> allowed time (i.e., the result says "Pass" for a 22:15 time, but stills
> says "Pass" for a 29:26 time). I tried changing the inequalities and
> text result ("Pass" or "Fail"), but have not had any success. Your
> help is greatly appreciated.
>
> Todd
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~View and post usenet messages directly from http://www.ExcelForum.com/
>