+ Reply to Thread
Results 1 to 2 of 2

Change formula if cell not numerical

  1. #1
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    365
    Posts
    430

    Change formula if cell not numerical

    Good afternoon all

    Merry Christmas and Happy New Year to you all

    Looking for some help with the ISNUMBER Function,, I have a range of cells with this formula,, it works very well giving me the result I require,, this is to return the hh:mm minus 15 minutes

    =IF(A8="","",IF(D8="-","",DGET($D$841:$E$1169,2,D7:D8)-0.25))

    What I'm looking for is if the cell D8 is not numerical then do not take the 15 minutes off the time.. ie run this formula...

    =IF(A8="","",IF(D8="-","",DGET($D$841:$E$1169,2,D7:D8)))

    I have been trying to make it work using the ISNUMBER function but cant get it to work,,,

    Many thanks

    JT

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,108

    Re: Change formula if cell not numerical

    perhaps you could give some examples of the data where isnumber does not work

    you have D8 contains a dash - or text or numbers

    can we see the ISNUMBER formula you used in your string as well
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Ignore blank cells with formulas or ignore NA() in a formula
    By guiismiti in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-24-2016, 02:13 PM
  2. Append numberical returned value to cell location
    By umang2382 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-24-2015, 05:52 PM
  3. [SOLVED] Result in cell based on cell on another tab in numberical order
    By jgregory43 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-02-2013, 06:52 PM
  4. [SOLVED] Copy numberical result (cell C5) to another cell (E5) as text value
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2013, 09:00 PM
  5. Formula won't ignore cell
    By MrPez in forum Excel General
    Replies: 2
    Last Post: 07-09-2010, 09:37 AM
  6. How do I ignore formula as a value in a cell?
    By Gooford in forum Excel General
    Replies: 4
    Last Post: 05-13-2010, 10:53 AM
  7. How to ignore formula in a cell
    By clayton in forum Excel General
    Replies: 1
    Last Post: 11-10-2006, 08:09 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