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

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

Thanks,
But I got it by just removing some ()

=IF(Contract="John",Points*50*Quantity,IF(Contract ="Willey",Points*20*Quantity, IF(Contract="Ernst",Points*500*Quantity,IF(Contrac t="Rad",Points*5*Quantity,""))))