Help Needed - And/If Statement (Multiple Functions)

**henrock24** · 03-11-2015, 11:52 AM

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","USA - No Score" or "USA – Cancel before Scoring".

So far I am able to get "Foreign", "USA - 640+", "USA - Under 640", and "USA - No Score" using the following formula in Column (AQ - 'Catergory'):

=IF(AH2="USA",IF(Z2="","USA - No Score",IF(Z2>=640,"USA - 640+","USA - Under 640")),"Foreign")

However, I need to incorporate into the above formula in order to also get "USA - Cancel Before Scoring" in which this criteria is:

Country – USA (Column AH)
SCORE – no score (Column z)
Status – X (Column U)
Detail – R, MO or BT (Column V)

Thank you for your help in advance!

Hendrix

**p24leclerc** · 03-11-2015, 06:55 PM

Try this formula in C2 and copy it down the column

Please Login or Register  to view this content.

The only question I had was what to write if
Country = USA (Column AH)
SCORE = no score (Column z)
Status = X (Column U)
but Detail <> R, MO or BT (Column V)
If this combination is possible, it will have the result "Nothing" that you can change to fit your needs.
If it's impossible, then you cna change the "Nothing" by "" (empty string)
Regards