Results 1 to 7 of 7

Formula to choose outcome from series of options

Threaded View

  1. #1
    Registered User
    Join Date
    03-17-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    3

    Formula to choose outcome from series of options

    Hello,

    I need excel formula to work based on below criteria. This is what i am trying
    =IF(A1>=10,"Q4",IF(AND(A1>5,A1<10),"Q3",IF(AND(A1>4,A1<8),"Q2","Q1")))

    What i need is below
    if A1 value is <4 then it should print Q1, if its between 5 and 10 it should print Q2,if between 10 and 12 it should print Q3, if greater than 12 it should print Q4.


    Thanks in advance.
    Last edited by AliGW; 03-17-2019 at 01:42 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA, User-defined formula argument referring to cell value calculated by Excel formula
    By ARAGORN II in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-23-2017, 01:57 PM
  2. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  3. Replies: 10
    Last Post: 12-16-2015, 03:16 PM
  4. Replies: 2
    Last Post: 03-21-2014, 11:43 AM
  5. Macro: Applying formula to multiple cells in excel (formula editing)
    By city in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2012, 06:41 AM
  6. Replies: 0
    Last Post: 03-19-2012, 07:32 PM
  7. Replies: 1
    Last Post: 03-04-2012, 12:03 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