+ Reply to Thread
Results 1 to 9 of 9

if (or....and....formula issue

  1. #1
    Forum Contributor
    Join Date
    04-27-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    113

    if (or....and....formula issue

    Hello

    here is my formula

    =IF(ISERROR(IF(OR(D10-C10<>1,C10="12+"),1,0)),1,IF(OR(D10-C10<>1,C10="12+"),1,0))

    C10 = 1
    D10 = 2
    E10 = 3
    .....N10 = 12

    i have numbers list from 1-12

    basically, if the number sequence is out of order, i want in C9:N9 to show 1 through this formula

    however, C10:N10 = 12+ .....then i want that to show 1 as well

    my formula for some reason doesnt seem to work when i make C10:N10 = 12+

    pls help!

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: if (or....and....formula issue

    do you mean 12 or greater? c10>=12
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Contributor
    Join Date
    04-27-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    113

    Re: if (or....and....formula issue

    the numbers are listed as 1, 2, 3...12, 12+ (which is ppl's tenure)

    basically i want to make sure they select the right sequential order....so if they select 9, 2, 3, 4...12 (i want to show error on first cell) or C9 where my formula is

    similarly, if it says 12, 12+, 12+...all the way through..that is okay as well....

    ur thoughts...thx u again!

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: if (or....and....formula issue

    post a sample workbook showing the results you expect

  5. #5
    Forum Contributor
    Join Date
    04-27-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    113

    Re: if (or....and....formula issue

    pls see attached

    cell conditioned for red highlight if they do not match thx u
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    04-27-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    113

    Re: if (or....and....formula issue

    any thoughts?

  7. #7
    Forum Contributor
    Join Date
    04-27-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    113

    Re: if (or....and....formula issue

    any suggestions for the sample posted?

  8. #8
    Forum Contributor
    Join Date
    04-27-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    113

    Re: if (or....and....formula issue

    anything yet guys??

  9. #9
    Forum Contributor
    Join Date
    04-27-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    113

    Re: if (or....and....formula issue

    ?????? anything guys

+ 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