+ Reply to Thread
Results 1 to 5 of 5

If(or( formula not working

  1. #1
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    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 Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    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
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    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 Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    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
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    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)

Similar Threads

  1. Format a part of a text working with only value not working with formula result
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2017, 05:41 AM
  2. [SOLVED] help index and match macro not working but formula working??
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2016, 06:37 AM
  3. Replies: 3
    Last Post: 05-14-2015, 07:32 AM
  4. Correct/Working (Index,Match) formula not working between cells
    By barnerd in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-11-2014, 01:20 PM
  5. Replies: 9
    Last Post: 03-08-2013, 11:50 AM
  6. Replies: 2
    Last Post: 08-17-2012, 08:16 AM
  7. Replies: 2
    Last Post: 08-01-2012, 11:53 AM

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