Adding IF AND criteria to existing IF Statement

I have an IF statement that as is it works perfectly. However I have the need to change the criteria which would require the addition of (I believe) of an AND OR statement). A copy of the formula is below (row 477 happens to be a specific example of this new criteria). This formula resides in column B.

Please Login or Register  to view this content.

C477 = Have Column Yes or -
E477 = Gauge (this is the new variable that the concatenation requires)

I would like the same concatenation however if the value in this cell is equal to or greater than 20, than "awg" is the text
if the value is less than 20, the (current) concatenation statement displaying "swg" would be correct

F477 = size, this is a fraction, the concatenation statement accounts for this format
G477 = this is an item name
P477 = this is an item name

I have attached a file example so you can see what I am saying. I have hidden all non-relevant rows and columns to make this easier. Row 476 shows 19 gauge, so if the formula works properly, in column B it should reflect 19swg 3/32 (as it does currently). Row 477 is 20 gauge, so once the formula works properly, this should display as 20awg 3/32. Thanks in advance for all your time and help. I have spent the last 2 hours, and 3 cups of coffee on trying to resolve this without success.

Originally Posted by JohnTopley

Try

=IF(OR(G477="",C477="-"),"-",IF(ISTEXT(F477),F477,IF(P477="Rings",CONCATENATE(E477,IF(E477>=20,"awg","swg "),TEXT(F477,"##/###")),F477)))

Perfect JohnTropley! Thank you so much! I knew I was trying to over complicate it and I was!