I had excell 2007 and i upgrade to 2016.
everything was working fine with 2007 and also excell 365
i have this nesting and how i can change to be able to used with excell 2016
=(IF(G3="STORAGE 1",".666666666",(IF(G3="STORAGE 2",".80",(IF(G3="TRANSPORTATION",".80",(IF(G3="STORAGE 1A",".66666666",(IF(G3="STORAGE 3",".771428571",(IF(G3="STORAGE 4",".753846154",(IF(G3="CONTAINER 20",".70",(IF(G3="CONTAINER 40",".70",(IF(G3="INCOMING 1",".90",(IF(G3="INCOMING 2",".90",(IF(G3="INCOMING 3",".90",(IF(G3="OUTGOING 1",".90",(IF(G3="OUTGOING 2",".90",(IF(G3="IMPORT FEE",".50"))))))))))))))))))))))))))))
thank you
everything was working fine with 2007 and also excell 365
i have this nesting and how i can change to be able to used with excell 2016
=(IF(G3="STORAGE 1",".666666666",(IF(G3="STORAGE 2",".80",(IF(G3="TRANSPORTATION",".80",(IF(G3="STORAGE 1A",".66666666",(IF(G3="STORAGE 3",".771428571",(IF(G3="STORAGE 4",".753846154",(IF(G3="CONTAINER 20",".70",(IF(G3="CONTAINER 40",".70",(IF(G3="INCOMING 1",".90",(IF(G3="INCOMING 2",".90",(IF(G3="INCOMING 3",".90",(IF(G3="OUTGOING 1",".90",(IF(G3="OUTGOING 2",".90",(IF(G3="IMPORT FEE",".50"))))))))))))))))))))))))))))
thank you