Please correct my IF function in excel 2016 mac

See more:

MS-Excel

I have made a formula of IF function to see that, If the value is equal to what i want then, then take a value from cell A and multiply by cell B. A simple example if what i want to do is below. The below is a sample of a nested if function.

=IF(J15="3mm",B16*K15,IF(J15="4mm",B17*K15,IF(J15="5mm",B18*K15,IF(J15="10mm",B19*K15))))
J15 is the drop down menu with all the values
B16:B19 is the value i want to receive if J15 is true
And i want to multiple B16:B19 with K15

The problem is with the bigger formula below that has about 16 nested ifs. If i write the code it works fine but the moment i close excel and open it, This is written =#VALUE! instead of my code. Below is the problematic formula

=IF(J28="1/2_Inch/1.5mm",$D$58*K28,IF(J28="3/4_Inch/1.2mm",$D$59*K28,IF(J28="3/4_Inch/1.5mm",$D$60*K28,IF(J28="1_Inch/1.2mm",$D$61*K28,IF(J28="1_Inch/1.5mm",$D$62*K28,IF(J28="1x2_Inch/1.2mm",$D$63*K28,IF(J28="1x2 Inch/1.5mm",$D$64*K28,IF(J28="1.5x1.5_Inch/1.5mm",$D$65*K28,IF(J28="1.5x1.5_Inch/2mm",$D$66*K28,IF(J28="2x2_Inch/1.5mm",$D$67*K28,IF(J28="2x2_Inch/2mm",$D$68*K28,IF(J28="3x3_Inch/3mm",$D$69*K28,IF(J28="3x3_Inch/4mm",$D$70*K28,IF(J28="4x4_Inch/4mm",$D$71*K28,IF(J28="4x4_Inch/5mm",$D$72*K28,IF(J28="4x4_Inch/6mm",$D$73*K28))))))))))))))))

Other details

1) The values such as 1/2_Inch/1.5mm & 3/4_Inch/1.2mm are all in one drop down menu
J28 is that drop down value

2) The cell D58 till D73 are the cells which have the value i want incase the J28 value is true
3) I am multiplying Cells from D:58 to D73 with K28.

Also strangely if i put this formula in windows excel it does not work at all, but it works in Mac if i put it all over again or if i just remove a few Quotation marks and put it back

I am using office 2016 mac and i also have windows 2016 excel

What I have tried:

I have tried to remove all spaces from the quotation marks but still does not work