Nested if not blank formula

[detriez]

I can seem to get the formula syntax to get this right

IF (A1 <>"" and B1<>"" and C1<>"") Then "Bronze"
IF (A1 <>"" and B1<>"" and C1<>"" and D1<>"" and E1<>"") Then "Silver"
IF (A1 <>"" and B1<>"" and C1<>"" and D1<>"" and E1<>"" and F1<>"" and G1<>"") Then "Gold"

 

[Scott Huish]

See if this works for you:

=IFERROR(VLOOKUP(COUNTA(A1:G1),{3,"Bronze";5,"Silver";7,"Gold"},2,0),"")

This assumes that the cells will be filled across in order to determine the outcome.

 

[detriez]

Thanks Scott,
This is a Data Scorecard so I need the specific columns to calculate the value (Bronze, Silver, Gold)

I got the first part (Bronze) of this to work but not the second (Silver)

=IF(AND([@[First Name]]<>"",[@[Last Name]]<>"",[@Email]<>"",[@[Company / Account]]<>"",[@Country]<>""),"Bronze",(IF(AND([@[First Name]]<>"",[@[Last Name]]<>"",[@Email]<>"",[@[Company / Account]]<>"",[@Country]<>"",[@Title]<>"",[@[State/Province]]<>"",[@[Job Classification]] <>""),"Silver")))

 

[GR00007]

If it is correct to say that if columns D thru G are empty then "Bronze", then if only F&G are empty then "Silver" else "Gold" then give this a try:
=if(D1&E2&F2&G2="","Bronze",if(F2&G2="","Silver","Gold"))

 

[Scott Huish]

If it is correct to say that if columns D thru G are empty then "Bronze", then if only F&G are empty then "Silver" else "Gold" then give this a try:
=if(D1&E2&F2&G2="","Bronze",if(F2&G2="","Silver","Gold"))

I think your D1 should be D2, but that's where I was going with my formula and the op said it was incorrect.

Perhaps:
=IF(AND(A1="",B1="",C1=""),"Bronze",IF(AND(A1="",B1="",C1="",D1="",E1=""),"SILVER",IF(AND(A1="",B1="",C1="",D1="",E1="",F1="",G1=""),"GOLD","")))

 

[GR00007]

You're not getting silver because you are checking the bronze fields again and finding some populated.

I gather from what you are saying that if you have any basic data (name/email/country...) then the row is at 'bronze' level
then if you have title/postal/job class the row is brought up to 'silver' and if there is any other data then 'gold'
If that is so, my suggestion is to check if all the 'gold' and 'silver' fields are empty then label 'bronze'; else check if gold fields are empty if so, this row is 'silver', all the rest are 'gold'
=if(D1&E1&F1&G1="","Bronze", if(F1&G1="","Silver", "Gold"))