Multiply number based on alpha character at the end

jjaidev · Jan 7, 2014

HI all,

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

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

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

NBVC · Jan 7, 2014

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)