Forum Discussion
Dcerone
Sep 13, 2021Copper Contributor
Assistance Creating a Custom Formula
Hey All, I want to create a formula that automatically calculates based on variables being changed The formula is below: 180lb user outputting 200 Watts: Convert patient weight to kg: 180/...
Juliano-Petrukio
Sep 13, 2021Bronze Contributor
You just need to put your variables into cells values and make a formula accordingly using your different constant values (as per output unit)
Lets say to convert Lbs to Kg
A2 its a variable where the user will input the weight in Lbs
=A2/2.2
By the way, there is a formula that can convert a lot of different units
CONVERT(Number,FromUnit,ToUnit)
Lets say to convert Lbs to Kg
A2 its a variable where the user will input the weight in Lbs
=A2/2.2
By the way, there is a formula that can convert a lot of different units
CONVERT(Number,FromUnit,ToUnit)