Excel Magic Trick 1317

Formulas for Total Insulin Units… And Excel’s Golden Rule & MAX Replaces IF

DESCRIPTION

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.

WORKBOOKS

Download “Excel Magic Trick 1301-1320” Excel-Magic-Trick-1301-1320.zip – Downloaded 345 times – 285 KB




Be the first to comment

Leave a Reply