Rounding decimals based on another column value

[sherifff]

Need help with rounding the numbers in a  column called "LabResults" based on values from other column called "LabTestName" , a single column has various lab tests, the requirement is to show the measurement values with different decimals for different tests.

Example

LabTestName   LabResults
T1-272                 20.1 (1 Decimal point)
T1-300                 54.4218 (4 decimals)
TBP                       30 ( No Decimals)
TS-200                  70.42 (2 Decimal points)
TCL-100                40.9 (1 Decimal Point)

Any suggestions would be highly appreciated.

[sherifff]

Thank you so much.  The logic worked for me.  Thanks for your help!

[NickolajJessen · Accepted solution]

Hi,

The columns names got melted together and i used 20.1111 as values for all entries, but this should do the trick, no :)?