How-To Geek on MSN

Stop saying you can’t program: You use Microsoft Excel

Coding is the act of translating a logical solution into a computer-readable form. This involves writing instructions using a ...
PC World

Use Excel’s DATE, WEEKDAY, IF, and IF/OR to make weekly schedules by task, event and team member

Excel’s SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR functions came to mind as I was watching a 1969 film called If It’s Tuesday, This Must Be Belgium, about American tourists on a whirlwind tour of ...

5 Hidden Excel Function Ideas for Cleaner, Quicker Sheets

Five hidden Excel rules show helper columns, LET, and LAMBDA in action, cutting errors and making updates quick for any ...
JournalofAccountancy

Use IFS function to calculate letter grades in Excel

To calculate letter grades based on a percentage score, you can use multiple nested IF statements in Excel, which can get rather complicated quickly. However, there is an easier way. Added by ...
How-To Geek on MSN

How to use the LET function in Microsoft Excel

If you're tired of repeated calculations, hard-to-read formulas, and sluggish Excel worksheets, the LET function is your solution. It assigns simple names to complex calculations, making formulas ...