There are several types of treatments and medical providers for which Medicare Part B pays 100% of the approved charges rather than the usual 80%, and to which the yearly Part B deductible does not apply. In these categories, you are not required to pay the regular 20% coinsurance amount.
Mulei-Cell Array Formulas. A multi cell array formula is used when the result of the formula is a range that takes up more than one cell. Some Excel functions are required to be entered this way as multi-cell array formulas making use of Ctrl+Shift+Enter, the most common of which is TRANSPOSE.
Guidelines and examples of array formulas. Turning some of the formulas in your worksheet into array formulas can make your worksheet more powerful and simplify it at the same time. A formula used as an array formula can do calculations on rows and columns of cells where you might otherwise need to use several formulas.