Results 1 to 3 of 3

IF OR ISERROR problem

Threaded View

jomili IF OR ISERROR problem 01-03-2011, 04:00 PM
DonkeyOte Re: IF OR ISERROR problem 01-03-2011, 04:06 PM
jomili Re: IF OR ISERROR problem 01-03-2011, 04:57 PM
  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,065

    IF OR ISERROR problem

    Okay, my formula doesn't work, and I'm at a loss. Here's what I want to do:

    IF O2 minus J2 is an error (because there's no values in O2 or J2), OR if O2 minus J2 is Zero or less, don't show anything. Otherwise, show the results of O2-J2. Code is below, but I've got something hosed and can't figure out what. Any help would be appreciated.


    =IF((OR(ISERROR(O2-J2),O2-J2<=0)),"",O2-J2)
    Last edited by jomili; 01-03-2011 at 04:59 PM.

Thread Information

Users Browsing this Thread

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

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