ML089

¦^´_ 7# p212
¦^´_ 5# PJChen
"[>5]5"¡Gªí¥Ü¤j©ó5ªº¼Æ¥þ³¡¬°5¡A¨ä¥L¤£ÅÜ¡C
¤W­z·§©À¤§À³¥Î¥i±qExcelªº»¡©úÀÉÀò±o¸Ô²Ó¸Ñ»¡¡H

¦^ÂÐ:   
Excelªº»¡©úÀɨS¦³¦¹»¡©ú¡A¦ý¥i¥H°Ñ¦Ò Àx¦s®æ®æ¦¡³]©w¤¤ªº - ¯S®í - ¹q¸ÜÃþ ¦³Ãþ¦ü°µªk¥i¥H°Ñ¦Ò¡C
±ß¤W¦^®a§Ú¦A§ä¤@¨Ç¸ê®Æµ¹¤j®a°Ñ¦Ò

¥ý°Ñ¦Ò Àx¦s®æ®æ¦¡³]©w¤¤ªº - ¯S®í

¤U¸ü (110.23 KB)

2013-5-8 18:37

p212

¦^´_ 6# ML089
Mr. ML089¡G±z¦n¡I
"[>5]5"¡Gªí¥Ü¤j©ó5ªº¼Æ¥þ³¡¬°5¡A¨ä¥L¤£ÅÜ¡C
¤W­z·§©À¤§À³¥Î¥i±qExcelªº»¡©úÀÉÀò±o¸Ô²Ó¸Ñ»¡¡H
¥i§_·Ð½Ð«üÂI°g¬z¡A´£¨Ñ«D¸ê°T­I´º¥X¨­¤§¦P¦n¾Ç²ß¡AÁÂÁ¡I

ML089

¦^´_ 5# PJChen


    "[>5]5")ªº·N«ä¤S¦ó¸Ñ?
¤j©ó5ªº¼Æ¥þ³¡¬°5¡A¨ä¥L¤£ÅÜ

PJChen

¦^´_ 4# ML089

½Ð±ÐTEXT¤£¬O¥Î¦b¤å¦r¤è­±ªº¨ç¼Æ,¬°¦ó·|¨Ï¥Î¥¦? "[>5]5")ªº·N«ä¤S¦ó¸Ñ?
=--TEXT(5/IF(AND(N1249<N1250,N1250>0),N1248,N1248)*N1249,"[>5]5")

ML089

=--TEXT(5/IF(AND(N1249<N1250,N1250>0),N1248,N1248)*N1249,"[>5]5")

p212

¦^´_ 1# PJChen

Sorry! ¥¼¬Ý²M±zªº»Ý¨D¡A¤W¦C(2#)ªº·N¨£½Ð©¿²¤¡C

p212

¦^´_ 1# PJChen

Q1249=IF(IF(AND(N1249<N1250,N1250>0),5/N1250*N1249,5/N1248*N1249)>5,5,IF(AND(N1249<N1250,N1250>0),5/N1250*N1249,5/N1248*N1249))

¥h°£§R°£½u³¡¥÷­×§ï¬°  Q1249=IF(AND(N1249<N1250,N1250>0),5/N1250*N1249,5/N1248*N1249)  §Y¥i¡A½Ð°Ñ¦Ò¡I