You can also use other Excel functions in IF statements to perform calculations. IF statements in Excel are my secret sauce for transforming spreadsheets into intelligent decision-making tools.

While functions are typically used for computational purposes, they can also be used to change a spreadsheet's overall look. Here's an example using Excel's MOD function.

Ashley Brown, Senior Director, Global Revenue Recognition, Workday “I use spreadsheets every day and love them for all the basic functions and for the organizational aspect of showing data.

Click the Insert Function button. ... So enter this formula into a cell off to the side of your spreadsheet matrix (such as cell F2): =FORMULATEXT(E2) and Excel displays the actual formula of E2.

I'm trying to do a "sumif" function in StarOffice that basically looks through a range of cells containing 6-digit numbers, and if the number matches, it sums a counter column (a column containing ...

Functions in popular spreadsheet programs such as Excel tend to be accessible via buttons in visible toolbars. By selecting one or more cells, then pressing a function button, ...