Results 1 to 3 of 3

Thread: array formula to nest several optional values from same cell

  1. 2014-04-04, 10:27 PM #1
    toony
    toony is offline
    Acolyte toony's Avatar
    Join Date
    Mar 2014
    Location
    UK
    Posts
    49
    Articles
    0
    Excel Version
    Excel 2016

    array formula to nest several optional values from same cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    All the OR statement formula below refers to the same cell AL2362. How could I make an array formula to put all the OR values in one without repeating AL2362= every time?

    =IF(OR(AL2362="waste",AL2362="Shunt",AL2362="GKN",AL2362=”no”,AL2362="BOS",AL2362="85"),"1")

    Thank you
    Reply With Quote Reply With Quote
  2. 2014-04-04, 11:58 PM #2
    Bob Phillips
    Bob Phillips is offline
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,846
    Articles
    0
    Excel Version
    O365
    I have already shown you that.
    Reply With Quote Reply With Quote
  3. 2014-04-05, 01:55 AM #3
    toony
    toony is offline
    Acolyte toony's Avatar
    Join Date
    Mar 2014
    Location
    UK
    Posts
    49
    Articles
    0
    Excel Version
    Excel 2016
    You actually did bob. Apologies and thanks again x urt help
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules

Gravatar by 1e2.it