=IF(RIGHT(F22)="M",LEFT(F22,LENB(F22)-1)*1024,IF(RIGHT(F22)="k",LEFT(F22,LENB(F22)-1)*1),IF(RIGHT(F22,1)>"-1"&RIGHT(F22)<"10",LEFT(F22,LENB(F22))/1024))