+ Reply to Thread
Results 1 to 3 of 3

Use if statement for a range +4 and -4 and write PASS / NOT PASS

  1. #1
    Registered User
    Join Date
    04-05-2013
    Location
    Panama
    MS-Off Ver
    Excel for Mac
    Posts
    9

    Exclamation Use if statement for a range +4 and -4 and write PASS / NOT PASS

    Hi im trying to create an if statement for number that are beyond ±4 but doesnt works here is my statement:

    Please Login or Register  to view this content.
    im trying to make for example if number is 5 or -3 then write NOT PASS in cell, but if number is 2 or -5 write PASS so if the number is beyond ±4 write NOT PASS in cell but if its not true then write PASS i dont know what im doing wrong.

    thank you very much.
    Last edited by alexistkd; 04-05-2013 at 06:54 PM.

  2. #2
    Forum Contributor ragavan.sridar1's Avatar
    Join Date
    11-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010, Excel 2003
    Posts
    208

    Re: Use if statement for a range +4 and -4 and write PASS / NOT PASS

    may be you can try it this way?

    Please Login or Register  to view this content.
    Thanks!
    Raga.

    Please,mark your thread [SOLVED] if you received your answer.

    Click the little star * below, to give some Rep if you think an answer deserves it.

    I learnt so many things from these links.

  3. #3
    Registered User
    Join Date
    04-05-2013
    Location
    dublin, Ireland
    MS-Off Ver
    Excel 2007/10
    Posts
    26

    Re: Use if statement for a range +4 and -4 and write PASS / NOT PASS

    =+IF(OR(G6<-4, G6>4), "NOT PASS", "PASS")

    this will return a pass for numbers -4, -3, -2, -1, 0, 1, 2, 3, 4 and a not pass otherwise

+ Reply to Thread

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