+ Reply to Thread
Results 1 to 3 of 3

Finding one criteria using multiple items

  1. #1
    Registered User
    Join Date
    01-02-2013
    Location
    PHILIPPINES
    MS-Off Ver
    Excel 2010
    Posts
    19

    Question Finding one criteria using multiple items

    Hi i have this code

    =IF(I2="Q1-2013", "30000000", IF(I2="Q2-2013", "50000000", IF(I2="Q3-2013", "60000000", IF(I2 ="Q4-2013", "55000000", "0") ) ) )

    which is they gonna if I2 is "Q1-2013", "Q2-2013", "Q3-2013", and "Q4-2013" then they will add a number it they match else input 0.
    however

    how will i do if I'm going to create something like this


    IF I2="Q1-2013" and A2="UPP" then input 30,000,000 else IF I2="Q2-2013" and A2="UPP" then input 50,000,000 ... etc
    else IF I2="Q1-2013" and A2="AII" then input 40,000,000 else IF I2="Q2-2013" and A2="AII" then input 55,000,000 ...
    else IF I2="Q1-2013" and A2="AZZ" then input 60,000,000 else IF I2="Q2-2013" and A2="AZZ" then input 85,000,000 ...

    something like that please help me

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Finding one criteria using multiple items

    The formula should be written as

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If you feel that it is complicated then write it in TWO and Merge it like the below:-
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Add both as single formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    01-02-2013
    Location
    PHILIPPINES
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Finding one criteria using multiple items

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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