Using Sample of Spreadsheet
A native function will not just help save you the excess work of typing in a custom-designed array formula, but nevertheless, it will probably execute faster. Particularly if you're doing numerous calculations. The spreadsheet ticked all of the boxes. MS Excel, on the flip side, can do each of the things Word may not. Thus, the very first step is to double check Excel's list of native functions to see whether there's already one that can do the calculations you are considering.