Scribd
Upload
13 views1 page

Excel Formula

Uploaded by

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

Excel Formula

Uploaded by

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

=Average()

=Sum()
=XLookup(name;rangeto see,range to we o/p) -> used to loop name in the given range
=Trim()-> used to remove whitespaces
=Len()-> gave of the selected value
=Upper()-> capital Letter
=Lowe()-> small Letter
=Proper()-> In Title formate as Manish Raj
=Concat()-> used to add the string togethers i.e
=Concat("We","me"," ", "tech")
=Find("letter",value)
=search("letter",Value)
=substitute("name"1,"name2")
=Lookup(Columvalue,what changes )
eg.Lookup(@Salary,__,__)
=Vlookup()-> is used for look entry into vertical columns;
Formula;=Vlookup(Value,Table name,Index of desire need, exact match0)
Note for Vloop the lookup column sholud be at left and found on be at right
Xlookup is used in 2019 above excel as
=Xlookup(Value given, colmn of given type, colmn whose value want )

=XLOOKUP(value1,Table1,XLOOKUP(value2,Table1[#Headers],Table1))

You might also like