ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¤p¾Ç¥Í°ÝÃD 6 (ÁÂÁÂ)

=VLOOKUP(AVERAGE(A1:C1),{0,0;0.6,1;1.5,2;2.5,3;3.5,4;4.5,5},2,1)

TOP

AVERAGE(A1:C1)¬OA1:C1ªº¥­§¡
§A¤£¬O­n¨D¥­§¡´N§âAVERAGE(A1:C1)§ï¬°(A1+B1+C1)/X¤£´N¦n¤F¶Ü¡H
¨ä¥Lªº³£¤£Åܪº¡C

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD