+ Reply to Thread
Results 1 to 10 of 10

Using If / and Statements with text

  1. #1
    Registered User
    Join Date
    07-05-2014
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    31

    Using If / and Statements with text

    Hello All, I am trying to figure out how to group categories of Gross Sales generated by each Group (By Credit Score catgory 'FICO', No 'FICO' Score, or Foreign) in a pivot table, but first I have to make a formula for this to be broken down in the attached table (I attempted to make formulas on the last 3 columns "AQ", "AR", "AS") but I would rather want one column to tell me either "Foreign", "USA - 640+", "USA - Under 640", or "USA - No Score".

    In order to make this formula possible I would need:

    Column AH - "Country" &
    Column Z - "FICO"

    Thank you for your help in advance!

    Hendrix
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: Using If / and Statements with text

    is this what you're looking for:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    ?
    Hope I could help - if your post has been solved don't forget to mark it as such.

    Clicking the * below is a great way to say thanks!

    "Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito

  3. #3
    Registered User
    Join Date
    07-05-2014
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    31

    Re: Using If / and Statements with text

    You are Close!...the only thing that is missing is "USA - No Score" how do you put that in as well? thanks!
    Last edited by henrock24; 03-06-2015 at 01:06 PM.

  4. #4
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: Using If / and Statements with text

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

  5. #5
    Registered User
    Join Date
    07-05-2014
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    31

    Re: Using If / and Statements with text

    Hey thanks again, however when I use that formula - I get "Foreign" instead of getting "USA - No Score". I need for when there is no score, and it is USA it is "USA - No Score"

  6. #6
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: Using If / and Statements with text

    the row you're referring to is not in the USA... it is foreign...

  7. #7
    Registered User
    Join Date
    07-05-2014
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    31

    Re: Using If / and Statements with text

    Hi again, Im not sure what you mean. But just to be clear I want either 4 categories 1)"Foreign", 2) "USA - 640+", 3) "USA - Under 640", and 4) "USA - No Score". The formula you gave me was a good one, but it only gave me 3 categories 1)"Foreign", 2) "USA - 640+", 3) "USA - Under 640"

  8. #8
    Registered User
    Join Date
    07-05-2014
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    31

    Re: Using If / and Statements with text

    Ohhh nevermind you are right! Thanks!!

  9. #9
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: Using If / and Statements with text

    glad I could help don't forget to mark it solved.
    Last edited by simarui; 03-06-2015 at 01:51 PM. Reason: OP posted first

  10. #10
    Registered User
    Join Date
    07-05-2014
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    31

    Re: Using If / and Statements with text

    I already marked it solved thank you for your help!!

+ 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] IF statements using only Text
    By Dutch01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2015, 04:58 PM
  2. If contains text statements that return text string
    By timbo86 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-29-2014, 10:46 AM
  3. IF STATEMENTS for text and different automatic outcomes/text.
    By filtrox in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2014, 08:16 PM
  4. IF statements to find certain text and exclude certain text
    By Barussell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2014, 04:38 PM
  5. IF text statements
    By CRVDiva in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-31-2005, 08:05 PM

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