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 SUMIF(): =SUMIF(range, criteria[, sum_range]) The East Caribbean Dollar, XCD, will be used in D9 to illustrate how SUMIF() can be used to rewrite nested IF()s. SUMIF() is very similar

Hi another video on top function in excel in my steemit as i promised Enjoy Doron