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

«ç»ò§Ö³tªººâ¥X¤Ï¨ç¼Æ­È

«ç»ò§Ö³tªººâ¥X¤Ï¨ç¼Æ­È

°²³]¦³¤@­Ó¨ç¼Æ¤½¦¡¬O³o¼Ë=(C6*C7)+9.36*LOG10(G5)-0.2+(LOG10((C9-C10)/(2.7))/(0.4+(1094/(G5^5.19))))+2.32*LOG10(C14)-8.07  
·|¦³C6 C7 G5 C9 C10³o¨Ç°Ñ¼Æ¡A¿é¤J«á¥iºâ¥Xµª®×¡A¦ý¬O°²³]¤µ¤Ñµª®×¤wª¾ ¨Ã¥B C6 C7  C9 C10°Ñ¼Æ©T©wªº±¡ªp¤U¡A­n¦p¦óºâ¥XG5¡A¤£ª¾¹D¦³¨S¦³¤ñ¸û§Öªº¤èªk
m06o2~~~~

¥»©«³Ì«á¥Ñ ML089 ©ó 2016-2-3 17:58 ½s¿è

¦^´_ 1# m06o2

G6 =(C6*C7)+9.36*LOG10(G5)-0.2+(LOG10((C9-C10)/(2.7))/(0.4+(1094/(G5^5.19))))+2.32*LOG10(C14)-8.07

{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

ª©¥D¤j¤j!!!!«D±`·PÁ±z  ¾Ç¨ì¤@­Ó·s§Þ¯à¤F!!!!!
m06o2~~~~

TOP

¦^´_ 2# ML089
ª©¥D±z¦n·Q¸ß°Ý¥t¥~¤@­Ó°ÝÃD¡A¦b¥Ø¼Ð­Èªº³¡¤À  ¥i¥HÅý¥L¦Û°ÊŪ¨ú¬Y¤@­Óªº¼Æ¦r¶Ü ¦]¬°¦pªG ¥Ø¼Ð­È¤]·|ÀHµÛ¨ä¥Lªº¼Æ­ÈÅÜ°Ê¡I¡I
m06o2~~~~

TOP

¦^´_ 4# m06o2

¨Ï¥ÎVBA

Sub ¥Ø¼Ð·j´M()
    Range("G6").GoalSeek Goal:=17.61664, ChangingCell:=Range("G5")
End Sub
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  m06o2

Sub ¥Ø¼Ð·j´M()
    Range("G6").GoalSeek Goal:=17.61664, ChangingCell:=Ra ...
ML089 µoªí©ó 2016-2-3 21:46

ª©¥D±z¦n¡A«D±`·PÁ±z¡A¦ý·Q½Ð°Ý 17.61664¥i¥H¬OŪ¬Y¤@­ÓÄæ¦ì¶Ü¡H¡H   ¦]¬°17.61664¬O¤@­Ó·|Åܰʪº  
¨Ï¥ÎVBA
m06o2~~~~

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2016-2-4 10:32 ½s¿è

¦^´_ 6# m06o2

¥i¥H¨Ï¥ÎÄæ¦ì
Sub ¥Ø¼Ð·j´M()
    For i = 1 To 10
        Range("G6").GoalSeek Goal:=Range("I6").Offset(, i), ChangingCell:=Range("G5")
        Range("I7").Offset(, i) = Range("G5")
    Next
End Sub

«ç»ò§Ö³tªººâ¥X¤Ï¨ç¼Æ­È.rar (14.62 KB)

Range("I7").Offset(, i) = Range("G5") ¬Oªñ¦ü­È·|¦³«Ü¦h¤p¼Æ¡A¥i¥H¥ÎROUND¨ç¼Æ¨ú¾ã¼Æ©Î¤p¼Æ´X¦ì
­×§ï¦p¤U
Range("I7").Offset(, i) = Round(Range("G5"), 0)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD