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

[µo°Ý] ·Q½Ð±Ð¦U¦ì°ª¤â...¦p¦ó«ü©w¤p¼ÆÂI§P©w¶i¦ì

[µo°Ý] ·Q½Ð±Ð¦U¦ì°ª¤â...¦p¦ó«ü©w¤p¼ÆÂI§P©w¶i¦ì

±ø¥ó:¤p¼ÆÂI«á¬°0~0.25ªº¬Ò¥H0.25ªí¥Ü
¤p¼ÆÂI«á¬°0.26~0.5ªº¬Ò¥H0.5ªí¥Ü
¤p¼ÆÂI«á¬°0.51~0.75ªº¬Ò¥H0.75ªí¥Ü
¤p¼ÆÂI«á¬°0.76¥H¤Wªº«hµL±ø¥ó¶i¦ìªí¥Ü
¨Ò¦p:KEY 2.21«h·|Åã¥Ü2.25
KEY 48.34«h·|Åã¥Ü48.5
KEY 66.66«h·|Åã¥Ü66.75
KEY 50.78«h·|Åã¥Ü51

¦A·Ð°ª¤â­Ì¤£§[«ü±Ð...ÁÂÁÂ

b1=IF(A1,CEILING(A1,0.25),0.25)

TOP

¦^´_ 1# ericjiang
=IF(A1="","",MAX(0.25,CEILING(A1,0.25)))

TOP

·PÁª©¥Dµ¹¤©«ü±Ð...¸U¤À·PÁÂ

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD