BRK.A股數為何需再除以1000
Mike,
恕我愚昧, 請教BRK.A的股數為何需要再除以1000? 有特別涵意嗎? Thanks!
1) version: 180411
2) 計算股數的儲存格I38 ~ I42, I47 ~ I51的公式中, 只要A2(公司代號) 為 BRK, 就除以1000; 如下紅字部份:
=IF(ISERROR(Z59),0,IF(Z59="-",0,IF(ISNUMBER(Z59),Z59,IF(LEFT(Z59,1)="(",-MID(Z59,2,LEN(Z59)-3),MID(Z59,1,LEN(Z59)-1)))*IF(ISNUMBER(Z59),0.000001,1)*IF(OR(RIGHT(Z59,1)="B",RIGHT(Z59,2)="B)"),1000,1)*IF(OR(RIGHT(Z59,1)="T",RIGHT(Z59,2)="T)"),1000000,1)))*IF(UPPER(LEFT(A2,3))="BRK",0.001,1)
|