10 Best formulas in Excel

Excel has provided a vast formula to perform different operations. 1. Sum Used for adding numbers Syntax Sum(Number 1, Number 2.,Number 9) or SUM( Starting location of data: Last location of data) Example sum(20,30,40) = 20+30+40 = 90 =SUM(A1:A8) = add all numbers updated in column A from row 1 to 8 =SUM(A1:B8) = add