Help with Date formulas and Price Differences in spreadsheet

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

Originally Posted by TMS

Couple of ways:

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

Thanks TMS - that helped a lot.
For the unsold properties I have used =IF(C3="",0,(C3-A3)/C3)
and for the sold properties I have used this: =IF(C20="",(A20-G20)/A20,(C20-G20)/C20)

But I am trying to combine the two, so as I enter in the sale price it will recalculate the discount figure
and thats where I am stuck.
Cheers

This formula =IF(C3="",0,(C3-A3)/C3 calculates the discount for the properties that are available and where there has been a price change whist on the market. (Rows 3-17 in the attached extract)

This forrmula =IF(C20="",(A20-G20)/A20,(C20-G20)/C20) calculates the discount once the property has sold (Rows 20-23 in the attachment)

What I would like is for the discount figure to update as soon as the sold price is entered in column 'G'.
So the discount will pick up the difference between Col G and Col C (if there has been a price change ) or Col A (if there has not been a price change)

I did play around with nesting IF commands, but not getting too far.
THanks

Originally Posted by JeteMc

If I understand correctly, then the following pasted into cell I3 and copied down may help:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

THanks JeteMc - awesome!