Monday, April 17, 2023

Add Excel Calculation with values expressed in different units (KB, MB, GB)

 =LEFT(A1,LEN(A1)-2)/10^((MATCH(RIGHT(A1,2),{"PB","TB","GB","MB","KB"},0)-3)*3)

No comments: