Results 1 to 2 of 2

Thread: Multiply number based on alpha character at the end

  1. #1

    Multiply number based on alpha character at the end



    Register for a FREE account, and/
    or Log in to avoid these ads!

    HI all,

    Need the solution for the below query. Please do assume I have a table as below.

    A 10G
    B 100G
    C 10F


    When ever a G is present in the values present in second column, I need the value of the number to be mutiplied by 1000. My output must be
    A 10G 10000
    B 100G 100000
    C 10F 10F


    What formula must I put in the third Column in order to get this result.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,436
    Articles
    0
    Excel Version
    Excel 2016
    Do you want the F to remain?

    If so, then:

    =IF(RIGHT(B1)="G",LEFT(B1,LEN(B1)-1)*10,B1)

    else use:

    =LEFT(B1,LEN(B1)-1)*IF(RIGHT(B1)="G",10,1)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •