Urgent Help

[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

<tbody>
</tbody>

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

<tbody>
</tbody>

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

 

[shvraka]

HI all,

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

A	10G
B	100G
C	10F

<tbody>
</tbody>

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

<tbody>
</tbody>

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

Formula is:

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

 

[jjaidev]

Thanks a lot