Closed Thread
Results 1 to 2 of 2

IF Function range definition - my formula i am overlapping?

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    IF Function range definition - my formula i am overlapping?

    Hi guys

    Think I am overlapping my criteria in an IF function which is not giving me right results.

    Please help:

    =IF(P2>99,"2",IF(P2<=98,"1",IF(P2<=96,"0")))

    I want to define if someone gets a score of 98 or below, their grade is 1.

    If they get 96 or below they get 0. But I am not seeing 0 in my results?

    pls advise

    many thanks!
    Thanks,

    R.



  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: IF Function range definition - my formula i am overlapping?

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: link to be added here
    HTH
    Regards, Jeff

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Application.Run Function Definition
    By efarkouh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-05-2016, 12:37 PM
  2. Replies: 3
    Last Post: 08-29-2016, 06:17 PM
  3. [SOLVED] Excel Formula/Function to find total number of non-overlapping months
    By akynyemi in forum Excel General
    Replies: 6
    Last Post: 09-07-2015, 06:15 PM
  4. Where is function reference and definition?
    By ngutman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-25-2013, 03:34 PM
  5. Dynamic range definition in array formula.
    By donjoe in forum Excel General
    Replies: 3
    Last Post: 12-22-2010, 02:05 PM
  6. Help with Range Definition
    By scottintexas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2008, 09:08 AM
  7. [SOLVED] definition of the range containing content
    By Martin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2005, 09:40 AM

Tags for this Thread

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