Thread: Simple Excel formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Simple Excel formula
Hi,

You can use a Lookup() function :

=LOOKUP(RIGHT(A1,1),{"B","G","K","M"},{1,100000000 0,1000,1000000})

HTH
Reply With QuoteReply With Quote