Excel Magic Trick 1317

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


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.


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

Be the first to comment

Leave a Reply