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

[µo°Ý] ¤j¼Ó¦@¤½°òª÷¸Õºâ

[µo°Ý] ¤j¼Ó¦@¤½°òª÷¸Õºâ

test1.rar (8.8 KB)

¤j¼Ó¦@¤½°òª÷¸Õºâ
§Ú¦Û¤v°µ¥X¨Ó¥X²{¤@­Ó°ÝÃD

ºâ¥X¤Q»õ¥H¤W¤§«á§ï

¤Q»õ¥H¤U«Ø¿vª«´N·|­Ë¦©
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA



§Ñ¤F©ñ¹Ï¤ù¤W¨Ó

Åý¦³¨Ç°ª¤H¤£¯à¤U¸üªþ¥óªº¤H

¥i¥H¤@°_°Q½×
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

¥i¥H¼ÒÀÀ§â¼Æ­È¶ñ¶i¥h¶Ü?
¤£¤Ó¤F¸Ñ§Aªº·N«ä~~
kuoliang

TOP

A5 =MAX(0,MIN(10^ROW(A3),E$3)-SUM(A$4:A4))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP


©êºp
¥i¯à§Ú»¡©úªº¤£²M·¡

20000©Wªº¸Ü¤j¼Óªº°òª÷·|¬O³o¼Ë



10000©Wªº¸Ü¤j¼Óªº°òª÷·|¬O³o¼Ë
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

¦^´_ 5# kkooo15

A5¤½¦¡¨S¿ù°Ú

A5¤½¦¡¿é¤J«á»Ý­n¦b©¹¤U½Æ»s¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  kkooo15

A5¤½¦¡¨S¿ù°Ú

A5¤½¦¡¿é¤J«á»Ý­n¦b©¹¤U½Æ»s¤½¦¡
ML089 µoªí©ó 2012-11-13 11:33


ÁÂÁ ML089 ¦Ñ®v
§Ú¦b¸Õ¤F¤@¤U
¨S°ÝÃD¤F

·PÁÂ!
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD