This is a report out of SAP, the column with Pounds 1 is automatically coming out of the system, the column Pounds 2 is a calculation that I had to manually do for over 5,000 line items. In column "Pounds 1" we have "LB" and "G" at the end of each number. I am trying to create a IF statement for everything with a "LB" to return the same number, but if it ends with a "G" multiply it by .0022046 to convert Grams (G) into Pounds (LB) (cell# *.0022046). I think the reason it is not working, bc it has some type of custom number formatting. When I do a Ctrl 1 on the cell it takes me to "Custom format cell" and when I do the comma style (,) it displays only the number and drops the ("LB" and "G"), any help would be greatly appreciated. Thank you.
|Pounds 1||Pounds 2|
This question generated 26 answers. To proceed to the answers, click here.
This thread is current as of October 15, 2014.