Here's one for you...(thanks for the help in advance)

Here is my formula

=IF(ISNUMBER(Z11),(IF((VLOOKUP(S11,Results!Q:R,2,0))>((VLOOKUP(AL11,Results!Q:R,2,0))+1),"W","L")),"")

The formula works perfect but I want the cell to display "P" if
VLOOKUP(S11,Results!Q:R,2,0))=((VLOOKUP(AL11,Results!Q:R,2,0))+1)

(NOTICE THE EQUAL SIGN INSTEAD OF THE > SIGN). If the numbers are equal I
need the cell to display "P" instead of "L". Thanks

=IF(ISNUMBER(Z11),(IF(VLOOKUP(S11,Results!Q:R,2,0)>(VLOOKUP(AL11,Results!Q:R
,2,0)+1),"W",IF(VLOOKUP(S11,Results!Q:R,2,0)=(VLOOKUP(AL11,Results!Q:R,2,0)+
1),"P","L"))),"")


--
HTH

Bob Phillips

"Jambruins" <[email protected]> wrote in message
news:[email protected]...
> Here is my formula
>
>
=IF(ISNUMBER(Z11),(IF((VLOOKUP(S11,Results!Q:R,2,0))>((VLOOKUP(AL11,Results!
Q:R,2,0))+1),"W","L")),"")
>
> The formula works perfect but I want the cell to display "P" if
> VLOOKUP(S11,Results!Q:R,2,0))=((VLOOKUP(AL11,Results!Q:R,2,0))+1)
>
> (NOTICE THE EQUAL SIGN INSTEAD OF THE > SIGN). If the numbers are equal I
> need the cell to display "P" instead of "L". Thanks

thanks, works perfectly

"Bob Phillips" wrote:

> =IF(ISNUMBER(Z11),(IF(VLOOKUP(S11,Results!Q:R,2,0)>(VLOOKUP(AL11,Results!Q:R
> ,2,0)+1),"W",IF(VLOOKUP(S11,Results!Q:R,2,0)=(VLOOKUP(AL11,Results!Q:R,2,0)+
> 1),"P","L"))),"")
>
>
> --
> HTH
>
> Bob Phillips
>
> "Jambruins" <[email protected]> wrote in message
> news:[email protected]...
> > Here is my formula
> >
> >
> =IF(ISNUMBER(Z11),(IF((VLOOKUP(S11,Results!Q:R,2,0))>((VLOOKUP(AL11,Results!
> Q:R,2,0))+1),"W","L")),"")
> >
> > The formula works perfect but I want the cell to display "P" if
> > VLOOKUP(S11,Results!Q:R,2,0))=((VLOOKUP(AL11,Results!Q:R,2,0))+1)
> >
> > (NOTICE THE EQUAL SIGN INSTEAD OF THE > SIGN). If the numbers are equal I
> > need the cell to display "P" instead of "L". Thanks
>
>
>