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.
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)
Bookmarks