If I understood correctly then you want to convert your value column in "Lb" unit based on the choice column.
[Unit Column] --> Choice column with choices: Kg, Ton, Lb
[Another Column] --> Column which contains actual value
Then use below formula:
=IF([Unit Column]="Kg", [Another Column] * 2.2046, IF([Unit Column]="Ton", [Another Column] * 2000, [Another Column] * 1))
[Another Column] * 1, you can also use only
[Another Column] (I have added it just for better understanding).
- Sometimes comma(
,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(
;) instead of comma(
- Make sure your value column (
[Another Column]) is of Number data type.
- Return your calculated field as Number.
- Calculated Field Formulas.
- IF function.