There are numerous ways of rewriting convoluted nested IF()s, only 8 of which are covered here to accommodate versions of Excel going back to 2000. Some rewrites use just 1 function. VLOOKUP() is the

Excel syntax for 1 use of REPT(): =REPT(text, number_times) UK Pound Sterling is back, this time in cell B11 to illustrate how REPT() can be used to rewrite nested IF()s. Unlike the other functions and