Python, C, C++, C#, PowerShell, Android, Visual C++, Java ...
Microsoft Excel Text Functions are useful to deal with textual data. In this article, we will discuss a few of the Text functions. ASC function This function returns the ASCII text (single-byte characters) from the given text. The given text may contain double-byte characters; then the double-byte characters will convert to single-byte characters. If the […]
Set of Logical Functions Microsoft Excel provides to return the logical value, either TRUE or FALSE are going to be discussed through this Article. The logical function TRUE The TRUE() function always returns the logical value TRUE. This function doesn’t have any arguments and when you call this function without parentheses, Excel will treat it […]
We have discussed exporting All content from the WordPress site in the Article “WordPress – How to Export All content from WordPress site?“. And also discussed how to export partial content from WordPress in the previous Article “WordPress – Export the Posts, Pages or Media content“. In this article, I would like to go through […]
I have explained a few logical functions in the Article “Microsoft Excel – Logical Functions – IF, IFERROR and IFNA formulas“. In this article, we will go through another set of logical functions AND, OR, and XOR. All of these formulas take multiple arguments; the first argument is mandatory and the other arguments are optional. […]
Microsoft Excel provides logical formulas to enable to select the data depending on the given criteria. For example, select the data; if some condition(s) satisfies. In this Article, we will go through; IF, IFERROR and IFNA Logical Functions in Microsoft Excel. IF function The syntax of this function is: =IF(condition, [true-value], [false-value]) IF function takes […]
Microsoft Excel provides another set of operators to deal with the concatenation of text and combine ranges of Cells for calculations. Concatenation Operator This operator ONLY works on text data. It concatenates the text values or the values in the reference Cells to produce the concatenated text. If you apply this with any other data […]
Microsoft Excel provides Comparison Operators to compare the values of two operands. You can give the values directly or you can give the Cell references when you use these operators in Excel formulas. Comparison Operators Excel’s comparison operators are useful to compare the values in two operands. You can compare two values or the values […]
I have re-installed Microsoft Outlook 2013 on my Windows 7 System and I have configured the mailbox to receive the mails. Once done, I have opened Outlook and observed that Favorites folder was not appearing. In my previous installation of Outlook 2013, it was there and it makes easy to access the folders from Favorites. […]
Microsoft Excel provides different types of Operators to evaluate Arithmetic Expressions. Arithmetic Operators in Excel deal with ONLY Numerical data. In this article, I am going to explain what are Arithmetic Operators and their usage in Microsoft Excel. Arithmetic Operators in Excel These are the Arithmetic Operators, to work on Numerical data. If you attempt […]
Microsoft Excel provides a great feature, Conditional Formatting, to apply the formatting to particular Cells when the given criteria are met. We can apply the formatting to a particular cell or range of cells. You need to select the Rule depending on your requirements to colorize or format the cells. In this article, I am […]
