David Kindness is a Certified Public Accountant (CPA) and an expert in the fields of financial accounting, corporate and individual tax planning and preparation, and investing and retirement planning.
=LET (Spend,SUMIF (T_Budget [Category],E2,T_Budget [Cost]),IFS (Spend>F2,"Over budget",Spend=F2,"Budget hit",Spend> (F2*0.9), ...
If you enjoy the massive time savings from these methods, don't stop there—there are many other ways to speed up your Excel workflow, like learning the keyboard shortcuts for executing complex tasks ...