Sub test()a=0.6 “X转换系数b=0.8 “Y转换系数For i=2 to 1000 If Cells(i,2)=“” then exit for Cells(i,5)=Val(split(Cells(i,2),”=“)(1))*a Cells(i,6)=Val(split(Cells(i.3),”=“)(1))*bNext End Sub
EXCEL我懂,你说的专业术语我不懂。所以如何提问很重要。