Results 1 to 13 of 13

Cannot replace #Div/O error

Threaded View

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    London,England
    MS-Off Ver
    Excel 2003
    Posts
    12

    Cannot replace #Div/O error

    Dear Members,
    I am using a worksheet based on which I need to make a pie chart. There are three main columns Last Serviced Date, Todays Date and Minimum Service Interval. The columns Minimum Service Interval has number 1,2,4 or is blank. The idea is to have these three values is my formula column. Maintained when difference between dates is <365, Not maintained when difference between dates > 365. What I am trying to do is put a formula which would do the following
    1.If Difference between Today's Date and Last Service Date > 365, then fill cell with Not Maintained
    2.If Difference between Today's Date and Last Service Date >365/(Minimum Service Interval), then fill cell with Not Maintained

    This is where the complications start
    In the second condition I want to be able to say if Minimum Service Interval is Blank, then use first condition, and fill cell with Not Maintained. Finally if the conditions above are not satisfied then fill cell value as maintained. I have attached an excel sheet to give some clarity
    Attached Files Attached Files
    Last edited by luckyk; 08-25-2013 at 10:14 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Error 400 - Search and Replace
    By alokie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2011, 06:58 PM
  2. Replace #value! error with 0
    By dgc1952 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2008, 01:18 PM
  3. [SOLVED] Error Message When Using Replace
    By Susan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2006, 10:10 AM
  4. Replies: 3
    Last Post: 10-24-2005, 01:05 PM
  5. Replace debug error box
    By davegb in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-13-2005, 01: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