Microsoft Excel Functions

SumIf function of Math Trig functions in Microsoft Excel 2016

SumIf function of Math Trig functions in Microsoft Excel 2016

SumIf function Formulas tab MS Excel Previous Post: Concatenate function of Text functions in Microsoft Excel 2016 Before we jump to know about this function in detail, let us understand few things. The SumIf function is very important in Microsoft Excel. Specifically, two functions i.e. “Sum” and “If” are combined together. It is part of the Math Trig functions […]

Read More →

Read More →

Concatenate function of Formulas tab in Microsoft Excel

Concatenate function of Formulas tab in Microsoft Excel

Concatenate function Text functions Excel 2016 Previous Post: Mid function of Formulas tab in Microsoft Excel 2016 In the last post we’ve discussed, it was about the Mid function. This function is helpful for extracting words or letters from the middle. For example, in a list of names having First, Middle and Last names, this function is quite […]

Read More →

Read More →

Mid function of Text functions in Microsoft Excel 2016

Mid function of Text functions in Microsoft Excel 2016

Mid function Formulas tab MS Excel 2016 Previous Post: Right function Function Library group Microsoft Excel 2016 The previous post was about on the Right function. It is part of the Text functions of the Formulas tab. Almost similar to the Left function, but a little bit different, it works from the right side. Ok, now let us […]

Read More →

Read More →

Right function of Formulas tab in Microsoft Excel

Right function of Formulas tab in Microsoft Excel

Right function of Text functions Excel 2016 Previous Post: Left function of Formulas tab in Microsoft Excel 2016 The Right function in Excel gets the right side numbers, characters, alphabets or texts by entering number of characters in the function, desired by the user to extract from any cell. Significantly, in this post, we’ll now get to know […]

Read More →

Read More →

Left function of Text functions in Microsoft Excel 2016

Left function of Text functions in Microsoft Excel 2016

Tenth Function Formulas tab (Text) MS Excel Previous Post: HLookup function Lookup & Reference Microsoft Excel 2016 In the last two previous posts, the HLookup and the VLookup function were being discussed. These functions are part of the Formulas tab ribbon. Also, we knew that “V” is for Vertical, while the “H” is for Horizontal. In a table, when we talk about […]

Read More →

Read More →

HLookup function of Formulas tab in Microsoft Excel 2016

HLookup function of Formulas tab in Microsoft Excel 2016

HLookup function of Lookup & Reference MS Excel Previous Post: VLookup function Lookup & Reference Microsoft Excel 2016 Alright, the previous post was on the VLookup function of the Formulas tab. Basically, this function helps us to retrieve answers referring from a column of a Table. Particularly, this table is in the Vertical direction. In fact, “V” is for Vertical, […]

Read More →

Read More →

Top