Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met or not.

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

Q. I know that Excel has many great features, but I struggle with being able to find all of them, or even knowing if a feature exists to perform certain operations. Do you have any suggestions? A. It ...