Multiply number based on alpha character at the end

[jjaidev]

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.

[NBVC]

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)