Can someone help me check this IF statement for this logic (is this the most efficient way to do it): If C9 = “Dade” and I3<3326 then “HOMERUN”

If C9 = “Broward” and I3<4220 then “HOMERUN”

If C9 = “Palm Beach” and I3<4326 then “HOMERUN”

If C9 = “Dade” and I3<4158 then “Community or HOMERUN”

If C9 = “Broward” and I3<5275 then “My Community or HOMERUN”

If C9 = “Palm Beach” and I3<5408 then “My Community or HOMERUN”Statement:

=IF(I3="","",IF(AND(C9="Dade",I3<3326),"HOMERUN",IF(AND(C9="Broward",I3<4220),"HOMERUN",IF(AND(C9="Palm Beach",I3<4326),"HOMERUN",IF(AND(C9="Dade",I3<4158),"Community OR HOMERUN",IF(AND(C9="Broward",I3<5275),"Community OR HOMERUN",IF(AND(C9="Palm Beach",I3<5408),"Community OR HOMERUN","")))))))

message edited by mecerrato

For one thing, the formula is never going to return "My Community or Homerun" because it is not included in the formula as a possible return value. There may be suggestions to offer, but there no sense in doing that until we see a correct version of either your criteria or formula.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thanks DerbyDad03 I did not mean to have the word "My" as part of the returned values, here is the correct criteria and statement (I also made another correction to the criteria): If C9 = “Dade” and I3<3326 then “HOMERUN or Community”

If C9 = “Broward” and I3<4220 then “HOMERUN or Community”

If C9 = “Palm Beach” and I3<4326 then “HOMERUN or Community”

If C9 = “Dade” and I3<4158 then “Community”

If C9 = “Broward” and I3<5275 then “Community”

If C9 = “Palm Beach” and I3<5408 then “Community”Statement (The formula works but I want to know if there is a better way of doing it.):

=IF(I3="","",IF(AND(C9="Dade",I3<3326),"HOMERUN or Community",IF(AND(C9="Broward",I3<4220),"HOMERUN or Community",IF(AND(C9="Palm Beach",I3<4326),"HOMERUN or Community",IF(AND(C9="Dade",I3<4158),"Community",IF(AND(C9="Broward",I3<5275),"Community",IF(AND(C9="Palm Beach",I3<5408),"Community","")))))))

I'm pretty sure this formula does the same thing as your formula. All I did was combine the 3 AND's that return same result and put them inside an OR. If any of the 3 AND's are true, the corresponding OR will be true. =IF(I3="","",

IF(OR(AND(C9="Dade",I3<3326),

AND(C9="Broward",I3<4220),

AND(C9="Palm Beach",I3<4326)),"HOMERUN or Community",

IF(OR(AND(C9="Dade",I3<4158),

AND(C9="Broward",I3<5275),

AND(C9="Palm Beach",I3<5408)),"Community","")))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History