Trying to Resolve #Name? Errors in Transition from Google Sheets to Excel

Which version of Excel? What does 16 mean - is it Excel 2016?

Remove @ signs from the formulae:

=(IFS($C2="Junior 15-18 Boys", "no", $C2="Junior 10-14 Boys", "no",$C2="Junior 15-18 Girls", "no",$C2="Junior 10-14 Girls", "no",$C2="Men 5", "yes",$C2="Women 5", "yes",$C2="Masters 40+ 1/2/3/4", "no",$C2="Masters 50+ 1/2/3/4", "no",$C2="Masters 60+ 1/2/3/4", "no",$C2="Men 4", "yes",$C2="Women 4", "yes",$C2="Women 1/2", "yes",$C2="Women 3", "yes",$C2="Men 1/2", "yes",$C2="Men 3", "yes",$C2="Masters 35+ 4/5", "no",$C2="Women Masters 40+", "no",$C2="Singlespeed Men", "no",$C2="Singlespeed Women", "no"))

=IF(B2="DNF","",INDIRECT(ADDRESS((B2+1),(IFS($C2="Junior 15-18 Boys", "13", $C2="Junior 10-14 Boys", "13",$C2="Junior 15-18 Girls", "13",$C2="Junior 10-14 Girls", "13",$C2="Men 5", "13",$C2="Women 5", "13",$C2="Masters 40+ 1/2/3/4", "15",$C2="Masters 50+ 1/2/3/4", "15",$C2="Masters 60+ 1/2/3/4", "15",$C2="Men 4", "15",$C2="Women 4", "15",$C2="Women 1/2", "15",$C2="Women 3", "15",$C2="Men 1/2", "16",$C2="Men 3", "16",$C2="Masters 35+ 4/5", "14",$C2="Women Masters 40+", "14",$C2="Singlespeed Men", "14",$C2="Singlespeed Women", "14")),4)))

=IF(B2="DNF","",
IF(L2="Yes",INDIRECT(ADDRESS((B2+1),(IF(L2="yes",(IFS(
COUNTIF($C$1:$C$500,$C2)>=81,24,
COUNTIF($C$1:$C$500,$C2)>=61,23,
COUNTIF($C$1:$C$500,$C2)>=36,22,
COUNTIF($C$1:$C$500,$C2)>=21,21,
COUNTIF($C$1:$C$500,$C2)>=11,20,
COUNTIF($C$1:$C$500,$C2)>=5,19,
COUNTIF($C$1:$C$500,$C2)<5,18)),"")))),""))

Try a global Find & Replace to delete the "@" from the formulas. I'm not sure why those were inserted in the conversion. Normally that would be inserted to prevent an expression from being interpreted as an array, but that doesn't seem to apply to the IF and IFS you are using.

What version of Excel are you using? I don't know what 16 is. It's better if you use the product name, like Microsoft 365, Excel 2013, Excel 2021 for Mac, etc. I don't know if your version even supports IFS.

IFS was new in Excel 2019, so I think the Excel version is wrong in the OP's profile. If not, then nested IF statements or a LOOKUP can replace the IFS function.

Given that the OP gets #NAME and IFS is the newest function in the formula (since EXCEL 2019),
this indicates that the OP uses an Excel version that is older than Excel 2019.

So apparently 16 stands for Excel 2016.
The function to be translated comes from Google sheets and it can IFS.

I got the name error, too, Hans, in 365. When I removed the @ signs, it disappeared, so although I agree that the OP probably has 2016, it is not 100% certain yet.

So I2 could be this:

Please Login or Register  to view this content.

J2 could be this:

Please Login or Register  to view this content.

Originally Posted by AliGW

I got the name error, too, Hans, in 365. When I removed the @ signs, it disappeared, so although I agree that the OP probably has 2016, it is not 100% certain yet.

I got it too, and it resolved when I hit F2 followed by ENTER. The @ signs were still there but then the function was recognized.