View Single Post
  #1   Report Post  
Mike B Mike B is offline
Junior Member
 
Posts: 7
Default 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