=LET (Spend,SUMIF (T_Budget [Category],E2,T_Budget [Cost]),IFS (Spend>F2,"Over budget",Spend=F2,"Budget hit",Spend> (F2*0.9),"Near budget",TRUE,"Within budget")) Let's break the formula down to ...
If you want to set an expiration date and password when sharing Excel files online, here is how you can do that. It is possible to do both in Excel Online. That said, you do not need to rely on other ...