Results 1 to 13 of 13

#DIV/0! - How do i avoid seeing this message?

Threaded View

  1. #1
    Registered User
    Join Date
    09-16-2016
    Location
    England
    MS-Off Ver
    Excel 2013
    Posts
    84

    #DIV/0! - How do i avoid seeing this message?

    Hello,

    I was wondering is someone can help me please.

    I have the attached spread sheet and I use it to monitor if I discount products do I see the uplift in sales.

    For Example:

    Product 1, I launched it on 21/12/18 and never sold any, discounted it on 26/04/18 and sold 2 in the last 2 weeks therefore averaging 1 per week.

    If I average 1 per week for the remaining 31 weeks of the year I should see a big percentage uplift, but because my original sales are zero I see the #DIVO/0! message, is there anyway to trick excel so I see my percentage?

    I hope this makes sense?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How can I avoid a message popup
    By Jazzzbo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-09-2013, 12:36 PM
  2. Avoid displayin an alert message
    By pezalmendra in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-17-2012, 02:42 PM
  3. IF function to avoid #DIV/0! error message
    By Si902 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2010, 02:42 AM
  4. How to avoid message about leaving data in clipboard?
    By modytrane in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-05-2010, 12:33 PM
  5. How to avoid pivot table's (blank) message
    By acsishere in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2008, 10:51 AM
  6. Replies: 1
    Last Post: 08-13-2006, 08:00 AM
  7. [SOLVED] Can I avoid annoying Update Links message
    By phillyjoe in forum Excel General
    Replies: 2
    Last Post: 10-29-2005, 10:05 AM
  8. How can avoid the security Macro message ...
    By John B in forum Excel General
    Replies: 1
    Last Post: 03-29-2005, 03:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1