Assistance Creating a Custom Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2746966%22%20slang%3D%22en-US%22%3EAssistance%20Creating%20a%20Custom%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2746966%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20formula%20that%20automatically%20calculates%20based%20on%20variables%20being%20changed%20The%20formula%20is%20below%3A%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CP%3E%3CSPAN%3E180lb%20user%20outputting%20200%20Watts%3A%3C%2FSPAN%3E%3C%2FP%3E%3C%2FDIV%3E%3CDIV%3E%3CP%3E%3CSPAN%3EConvert%20patient%20weight%20to%20kg%3A%20180%2F2.2%20%3D%26nbsp%3B%3CSTRONG%3E81.82kg%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FDIV%3E%3CDIV%3E%3CP%3E%3CSPAN%3EConvert%20watts%20to%20kcal%2Fmin%3A%20200%20x%200.0143%20%3D%26nbsp%3B%3CSTRONG%3E2.86%20kcal%2Fmin%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FDIV%3E%3CDIV%3E%3CP%3E%3CSPAN%3EConvert%20kcal%2Fmin%20to%20litres%20O2%2Fmin%3A%202.86%20kcal%2Fmin%20%2F%205.05%20kcal%2FL%20O2%20%3D%20.%3CSTRONG%3E567%20litres%20O2%2Fmin%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FDIV%3E%3CDIV%3E%3CP%3E%3CSPAN%3EConvert%20liters%20O2%2Fmin%20to%20ml%2Fkg%2Fmin%3A%20.567%20litres%20O2%20x%201000%20mL%20litre%20%3D%26nbsp%3B%3CSTRONG%3E567%20mL%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FDIV%3E%3CBLOCKQUOTE%3E%3CP%3E%3CSPAN%3E567mL%2Fmin%20%2F%2081.82kg%20%3D%26nbsp%3B%3CSTRONG%3E6.93%26nbsp%3BO2%2Fkg%C2%B7min%26nbsp%3B%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EConvert%20mL%26nbsp%3BO2%2Fkg%C2%B7min%20to%20METs%3A%26nbsp%3B%3CSTRONG%3E6.93%20O2%2Fkg%C2%B7min%20%2F%203.5mL%2Fkg%2Fmin%20%3D%201.98%20METs%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E5.05%20kcal%2FL%20O2%2C%26nbsp%3B1000%20mL%20litre%2C%20and%3CSTRONG%3E%26nbsp%3B3.5mL%2Fkg%2Fmin%20are%20all%20%22constants%22%20Ideally%20would%20love%20a%20way%20to%20calculate%20this%20in%20a%20form%20type%20of%20setting%20when%20it%20automatically%20computes%20the%20end%20result.%26nbsp%3B%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FBLOCKQUOTE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2746966%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2747005%22%20slang%3D%22en-US%22%3ERe%3A%20Assistance%20Creating%20a%20Custom%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2747005%22%20slang%3D%22en-US%22%3EYou%20just%20need%20to%20put%20your%20variables%20into%20cells%20values%20and%20make%20a%20formula%20accordingly%20using%20your%20different%20constant%20values%20(as%20per%20output%20unit)%3CBR%20%2F%3ELets%20say%20to%20convert%20Lbs%20to%20Kg%3CBR%20%2F%3EA2%20its%20a%20variable%20where%20the%20user%20will%20input%20the%20weight%20in%20Lbs%3CBR%20%2F%3E%3DA2%2F2.2%3CBR%20%2F%3E%3CBR%20%2F%3EBy%20the%20way%2C%20there%20is%20a%20formula%20that%20can%20convert%20a%20lot%20of%20different%20units%3CBR%20%2F%3ECONVERT(Number%2CFromUnit%2CToUnit)%3C%2FLINGO-BODY%3E
New Contributor

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/2.2 = 81.82kg

Convert watts to kcal/min: 200 x 0.0143 = 2.86 kcal/min

Convert kcal/min to litres O2/min: 2.86 kcal/min / 5.05 kcal/L O2 = .567 litres O2/min

Convert liters O2/min to ml/kg/min: .567 litres O2 x 1000 mL litre = 567 mL

567mL/min / 81.82kg = 6.93 O2/kg·min 

Convert mL O2/kg·min to METs: 6.93 O2/kg·min / 3.5mL/kg/min = 1.98 METs 

 

5.05 kcal/L O2, 1000 mL litre, and 3.5mL/kg/min are all "constants" Ideally would love a way to calculate this in a form type of setting when it automatically computes the end result. 

 

 

1 Reply
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)