Formula Help - Easy for somebody

I have three clients that get billed at different rates, here is the
formula I have

=IF(contract=John,(J11*50)*B11),IF(contract=Willey,(J11*20)*B11),IF(contract=Ernst,(J11*500)*B11)

But I only get the rate for John? Can anybody fix this?

Thanks


--
Mike B

Something like:

=IF(Contract<>"",(J11*VLOOKUP(Contract,{"John",50;"Willey",20;"Ernst",500},2,0))*B11,"")

Mike B wrote:
> I have three clients that get billed at different rates, here is the
> formula I have
>
> =IF(contract=John,(J11*50)*B11),IF(contract=Willey,(J11*20)*B11),IF(contract=Ernst,(J11*500)*B11)
>
> But I only get the rate for John? Can anybody fix this?
>
> Thanks
>
>