Tools like Excel and Google Sheets are ubiquitous these days, and learning how to use them more effectively will quickly enhance your daily work. Alas, spreadsheets aren't always the easiest thing to ...
=LET (Spend,SUMIF (T_Budget [Category],E2,T_Budget [Cost]),IFS (Spend>F2,"Over budget",Spend=F2,"Budget hit",Spend> (F2*0.9), ...
To display a tooltip, you may use Comments, Notes, Data Validation Help Text, or Screen Tips. Let us see how they work in Excel and Google Sheets.