´M§ä³æÄd¤º¶Ç¦^ªºÈn¤j©ópºâÈ
- ©«¤l
- 44
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 74
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-6-24
- ³Ì«áµn¿ý
- 2023-9-21
|
´M§ä³æÄd¤º¶Ç¦^ªºÈn¤j©ópºâÈ
¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-6-28 11:29 ½s¿è
¤j®a¦n¡G
§Ú¦³¤@Äæ¸ê®Æ¦p¤U¡G
A
1 0.25
2 0.37
3 0.55
4 0.75
5 0.92
6 1.1
7 1.5
8 1.84
§ÚªºB1Äæ¸ê®Æ¬Oo.4519¡A¦bCÄæ¿é¤J¤½¦¡¡G=Lookup(b1,$A$1:$A$8)¡Aµ²ªGÅã¥Ü0.37¡C
½Ð±Ð§ÚnÅã¥Ü¬O¤ñ0.4519¤jªºÈ¤]´N¬O0.55¡AY¬OB1¬O0.37´Nª½±µÅã¥Ü0.37¡C
lookup§ä¤£¨ì¬Û¦PÈ´N·|´M§ä²Å¦X¦¸¤pÈ¡A§Únªº¬O¦¸¤jÈ¡C
½Ð±Ð¦p¦ó¸Ñ¨M?·PÁ |
|
|
|
|
|
|
- ©«¤l
- 44
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 74
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-6-24
- ³Ì«áµn¿ý
- 2023-9-21
|
¦U¦ì¥ý¶i¦n¡G
§Ú¨Ì¾Úgong´£¨Ñ¸ê®Æ¿é¤J¨S°ÝÃD¡A¥i¬O¤µ¤éµo²{¤@Ó°ÝÃD¡A¦³¤@ÓÄd¦ìȤj©ó1.84µ²ªGÅã¥Ü#NUM!¡C
½Ð±Ð¹ï©ó¤j©ó³Ì«á¤@Ó¼ÆȪº¸ê®Æ¦p¦óÅã¥Ü1.84´N¦n?
·PÁÂ |
|
|
|
|
|
|