Despite having worked in Microsoft Excel for decades, I'm always learning new ways to speed up my workflow. Specifically, ...

because I wanted Excel to work out whether cell B2 was blank, and either return "Data required" (if B2 was blank) or multiply the value in B2 by seven (if it wasn't blank). I then used AutoFill to ...