Excel Sum KB, MB, GB, TB normalised to GB

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