yogi_Convert Entries Ending With B M K Into Numbers As Billions Millions And Thousands

                Google Spreadsheet   Post  #1839

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-20-2014

post by Timothy Niemeyer:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/69kHP9pVakE)
Multiple Len, Substitute, Right (B ,M, or K) Conundrum

Problem Description: I'm importing data from a website that either gives a string, for example, 120B (billion), 134M (million), or 75K (thousands). I've been able to use the formula to turn it into a number if it's billions (B) or millions (M) but am having trouble accounting for thousands (K). Here's what I have so far...

=if(len(C6), substitute(C6, right(C6,1), "")*if(right(C6,1)="B",1000000000, 1000000) ,)

Please help. Here's a sample formula...

https://docs.google.com/spreadsheets/d/1m2mt84DY0WaxvfPew65KYmSzYKq51LQlgKolgqL22Ew/edit?usp=sharing

Thank you in advance

---------------------------------------------------------------------------------------