Results 1 to 10 of 10

Determine if a cell value is within upper and lower bounds?

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    5

    Determine if a cell value is within upper and lower bounds?

    Hi guys,

    This should be an easy one, but it isn't working in Excel for me.

    I basically want to do this formula:

    IF((Setpoint-0.6) <= Result <= (Setpoint+0.6), "OK", "FAIL")

    It does not work because of how Excel treats comparisons. I've tried doing something like IF(Result => (Setpoint-0.6) AND Result <= (Setpoint+0.6), "OK, "FAIL") but it just gives me a #NAME? error.

    Any way of doing this?
    Last edited by Darksabre; 06-03-2013 at 01:13 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