+ Reply to Thread
Results 1 to 5 of 5

If(or( formula not working

  1. #1
    Forum Contributor
    Join Date
    03-30-2014
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    154

    If(or( formula not working

    I am trying to get this formular to work in H2
    and i get errors no matter which way i put this in H2 and copy down

    =IF(B2="1st",IF(B2="2Nd",IF(B2="3rd".1.0)))

    any help to get this working will be appreciated

    Regards
    Graham

  2. #2
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,134

    Re: If(or( formula not working

    What do you mean "not working"?

    As written, that formula should return only FALSE.
    Please describe, in words, what results you want depending on the entry in B2.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Contributor
    Join Date
    03-30-2014
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    154

    Re: If(or( formula not working

    Thanks for looking at this formula

    in H2 I would like the result of the If formula to return value of G2 or Blank

    I realize I did not put that in as to what i required

    so I am saying In H2 if B2 -"1st" or B2 ="2nd" or b2 -"3rd" then return value in G2 or leave Blank

    Regards
    Graham

  4. #4
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,134

    Re: If(or( formula not working

    Try
    =IF(OR(B2="1st",B2="2nd",B2="3rd"), G2, "")

  5. #5
    Forum Contributor
    Join Date
    03-30-2014
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    154

    Re: If(or( formula not working

    What too u so Long
    Thanks very much fot that, works a treat as u would know
    Appreciate that Mikerickson
    Regards Graham

+ 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