Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

Michael Boyle is an experienced financial professional with more than 10 years working with financial planning, derivatives, equities, fixed income, project management, and analytics. Pete Rathburn is ...

I usually prefer writing my own logic in Excel, so I was hesitant to start using the Formula by Example tool. But when it turned my manual patterns into a perfectly structured formula, it became the ...