The simplest use of the FORMULATEXT function is straightforward formula auditing.
Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates. Explore Get the web's best business technology news, tutorials, reviews, trends, ...
=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 ...