I'm curious as to why you say "It's ugly but it works"? As far as a spreadsheet goes, it's pretty commonplace.
How many different properties are there? If you know that and what their rates are, you could create a table listing the properties and their rates, then in your formula, use something like the VLOOKUP function to lookup the rates for the property. You could then create a cell with a dropdown list of the various properties and each manager would only need to select the property from the dropdown and the rates for that property would automatically be used in the formula.
Here's a link to info about how to create the dropdown list: http://office.microsoft.com/en-us/ex...005202215.aspx
You could put the table on sheet 2 so it wouldn't be seen and then your spreadsheet wouldn't be "ugly".
In the example below, when the property is selected from the dropdown list, the values for C1 & D1 would be looked up in the table with the formula "=VLOOKUP(B1, G20:I23, 2)" in cell C1, and "=VLOOKUP(B1, G20:I23, 3)" in cell D1.