Scribd
Upload
0 views1 page

Excel Basic To Advanced Formulas

Uploaded by

upenderrao1976
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0 views1 page

Excel Basic To Advanced Formulas

Uploaded by

upenderrao1976
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Excel Basic to Advanced Formulas

Basic: =A1+B1, =A1-B1, =A1*B1, =A1/B1, =SUM(A1:A10), =AVERAGE(A1:A10), =MIN(), =MAX(),


=COUNT(). Intermediate: =IF(), =AND(), =OR(), =COUNTIF(), =SUMIF(), =LEFT(), =RIGHT(),
=MID(), =LEN(), =CONCAT(). Advanced: =XLOOKUP(), =INDEX(), =MATCH(),
=INDEX(MATCH()), =FILTER(), =SORT(), =UNIQUE(), =TEXT(), =TEXTJOIN(), =IFS().

You might also like