See how to create formulas to calculate Insulin needed with the formula inputs: Total Carbs in grams, Carb Ratio, Blood Glucose Test, Blood Glucose Target, Correction Factor:
(00:12) Problem Setup
(00:25) Excel’s Golden Rule
(01:30) Formulas to make calculations including IF Function and FLOOR Function.
(06:16) MAX Function as a substitute for the IF Function when the calculation must be positive or zero, but not negative.