+ Reply to Thread
Results 1 to 4 of 4

Stacked IF statement

  1. #1
    Registered User
    Join Date
    11-14-2020
    Location
    England
    MS-Off Ver
    2010
    Posts
    1

    Stacked IF statement

    Hi All,

    I am trying to write IF statement to return a value based on the combination of a number of cells contents.

    A B C D
    15M L50 1HR L50 4HR L50 Daily L50
    Sell Zone Sell Zone Sell Zone Sell Zone

    If all 4 cells say Sell Zone I want to return - All ALIGNED
    If 15M, 1HR and 4HR say Sell Zone I want to return - 15M, 1HR and 4HR aligned
    If 15M and 1 HR say Sell Zone I want to return - 15M and 1HR aligned

    So far I have this:
    =IF(B2=A2"15M and 1HR Aligned",IF(C2=B2,"1HR AND 4 HOUR ALIGNED",IF(B3, C3, D3=A,"ALL ALIGN")))
    Which really isn't there, but I am not sure where to start to change things.

    Any of you excel wizards able to help? Bug thanks upfront for anyone who takes the time to help

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,603

    Re: Stacked IF statement

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,034

    Re: Stacked IF statement

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,034

    Re: Stacked IF statement

    Is this now resolved? Or, at least, moved on?

+ 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. [SOLVED] Combine stacked columns and stacked bars in a chart
    By maboho93 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-09-2018, 07:52 AM
  2. Replies: 1
    Last Post: 08-24-2016, 04:15 PM
  3. Stacked Conditional Formatting based on values from an IF statement?
    By nscarritt in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-21-2013, 11:24 AM
  4. Stacked bar chart with stacked secondary axis markers - please help!
    By Boardlady in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-22-2013, 10:32 AM
  5. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  6. Replies: 1
    Last Post: 03-26-2005, 02:06 PM
  7. [SOLVED] To create a stacked column chart and group the stacked bars togeth
    By Jacqueline in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1