Results 1 to 2 of 2

Thread: Dividing by Zero Formula Solution

  1. #1
    Neophyte gflory's Avatar
    Join Date
    Feb 2019
    Excel Version
    Office 365

    Dividing by Zero Formula Solution

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am a real estate agent that uses an Excel spreadsheet to track real estate activity in our market. One of the measurements is called Months-Of-Inventory. This number tells me the number of months needed to sell existing inventory based on the average of previous 12 months sales. Formula is inventory divided by average of previous 12 months sales.

    Here is the problem:

    In one specific high-end price range, there is 19 active listings (homes for sale), but zero sales for the past 12 months. Cannot find solution to dividing a number by zero to arrive at a whole number that represents months of inventory.

    Any ideas would be greatly appreciated!
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	MOI-2019.jpg 
Views:	6 
Size:	106.6 KB 
ID:	8880   Click image for larger version. 

Name:	MOI-2018.jpg 
Views:	6 
Size:	110.2 KB 
ID:	8881  

  2. #2
    Acolyte Heyjoe's Avatar
    Join Date
    Jan 2019
    Excel Version
    I think you have more of a math problem than an excel problem.

    Your formula is inventory/average of the previous 12 months sales. Let's abbreviate this to inv/s.

    Is there a real estate publication that indicates an industry average for how long it takes to sell these very expensive homes? Let's say the industry average is 14. We will use ia for industry average. So we could change the formula so that the ia of 14 will be used if the last 12 months sales are zero.

    So the formula would be IF(s = 0,ia,inv/s).

    You would asterick the worksheet to say that the industry average is used if the last 12 months sales are 0.
    Last edited by Heyjoe; 2019-02-12 at 08:45 PM. Reason: spelling errors

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts