HI

As a new estate agency, we are tracking our local real estate prices / time on market to benchmark ourselves agains the compeition.

In the extract from our spreadsheet below, we have the Time on Market for properties on the market sorted now (thanks),
But not sure to how to write the discount formula (from original asking price) when there has not been a price change, so that zero (0% shows in the discount column.

Then in the SOLD section, we propose to just drag the line down from "On Market", add in the sold date and selling price and have the Time on Market and Discount automatically change to the Sold price and date.

I'm fine using excel to prepare budgets / cash flow / etc, but these functions are a bit of a learning curve!

Thanks

Book3.xlsx