Mathematical and logical operations can be performed on a Microsoft Excel workbook with the help of formulas. One of the most common uses of Excel is to compare rows of data by using an IF statement.

REDUCE allows you to iterate through your data, building your result step-by-step, in the same way a loop operates in a programming language. Instead of scattering your intermediate calculations ...

Multiplying an entire Excel column by the results of a formula can be a little tricky, especially if the formula is complicated or subject to change. To simplify to process, use an absolute reference ...