漂亮男人線上看tv, 韓劇漂亮男人線上看, 漂亮男人線上看7漂亮男人線上看 tv,漂亮男人劇情大網,漂亮男人結局,漂亮男人演員《漂亮男人》

應該是IF超過七層有問題,你可以試試先不要那麼多層.

<第一>:分二段寫
E2=IF(D2>100%,60,IF(D2>99%,59,IF(D2>98%,58,IF(D2>97%,57,
IF(D2>96%,56,IF(D2>94%,54,IF(D2>92%,52,IF(D2>90%,50,F2))))))))

F2=IF(D2<=80%,45,IF(D2<=85%,46,48))

<第二>:用lookup(若D2小數點位數太多可能會有問題)
E2=LOOKUP(D2,{0,80,85,90,92,94,96,97,98,99,100}*1%+0.0000001,{45,46,48,50,52,54,56,57,58,59,60})

<第三>:用excel2010試試

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers. Five Filters recommends: 'You Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html