該公式將負數轉換為正數,反之亦然,但我怎樣才能讓所有數字都Col8變成正數?
=query(UNIQUE(IMPORTRANGE("https://docs.google.com/spreadsheets/d/ddddddddddddsssssssssssssssswwwwwwww/edit";"Sheet1!A1:K"));"select Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8*-1 where Col2 matches '"&B6&"' label Col8*-1 'Qtd' ")

轉載請註明出處,本文鏈接:https://www.uj5u.com/yidong/446580.html
