+ Reply to Thread
Results 1 to 4 of 4

if and isnumber, isnumber - then perform calculation.

  1. #1
    Registered User
    Join Date
    10-11-2018
    Location
    New Mexico
    MS-Off Ver
    2010
    Posts
    52

    if and isnumber, isnumber - then perform calculation.

    I want a cell to do this calculation: ((RC[-1]-RC[-2])*24)-0.5

    I'm trying to enter it so that the calculation only takes place if there are values in RC[-1] and RC[-2]. If either of those cells are blank, I do not want it perform the calculation.

    This is the closest I've gotten: =IF(AND(ISNUMBER(RC[-1])),(ISNUMBER(RC[-2])),(((RC[-1]-RC[-2])*24)-0.5))

    Yet, this only returns the word "true" in the cell. It is in fact true, but I want "true" to mean that it then performs the equation. I've tried tacking on a false value as well, but that says there are too many arguments.

    Please advise.

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2404
    Posts
    13,407

    Re: if and isnumber, isnumber - then perform calculation.

    You had an extra set of () around the ISNUMBER(RC[-1]) part. AND was evaluating only that part. Also ISNUMBER(RC[-2]) by itself evaluates as TRUE. I removed several other () that were unnecessary.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by FlameRetired; 10-19-2018 at 02:59 PM.
    Dave

  3. #3
    Registered User
    Join Date
    10-11-2018
    Location
    New Mexico
    MS-Off Ver
    2010
    Posts
    52

    Re: if and isnumber, isnumber - then perform calculation.

    I can finally tack on my false value as well! Thank you very much :-)

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2404
    Posts
    13,407

    Re: if and isnumber, isnumber - then perform calculation.

    You are welcome. Glad to help. Thank you for the feedback, added rep and marking your thread Solved.

+ 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. Using IF(ISNUMBER with OR
    By VCDTF191 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-03-2015, 02:00 PM
  2. USING IF ISTEXT OR ISNUMBER THEN INDEX MATCH OR calculation
    By pippib in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2012, 01:26 AM
  3. If (isnumber)
    By bmoney in forum Excel General
    Replies: 3
    Last Post: 01-10-2012, 02:52 AM
  4. ISNUMBER AND OR Help Please
    By onetrade in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 06-18-2009, 03:20 PM
  5. Isnumber
    By 3smees23 in forum Excel General
    Replies: 5
    Last Post: 06-18-2009, 05:03 AM
  6. If isnumber
    By SOMLSS1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-24-2008, 10:56 PM
  7. [SOLVED] ISNUMBER
    By Michael Nol in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2006, 08:30 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