Whenever we prepare any report in excel, we have two constituents in any report.
The Text portion and the Numerical portion.
But just storing the text and numbers doesn’t make the super reports. Many times we need to automate the process in the reports to minimize the effort and improve the accuracy.
Many functions are provided by the Excel which work on Text and give us the useful output as well. But few problems are still left on which we need to apply some tricks with the available tools.
In this articles , we are going to use the TEXT with IF STATEMENT which is a very practical scenario and is used a lot while preparing reports.
TEXT IS AN INACTIVE NUMBER TYPE[FORMAT] IN EXCEL. ANYTHING STORED AS TEXT [NUMBER OR DATE] WON’T RESPOND TO ANY STANDARD FORMULAS OR FUNCTIONS BUT SPECIALLY DESIGNED TEXT FUNCTIONS. [EXCEPTIONS DO OCCUR IN CASE OF NUMBERS]
IF function is one of the most important function in Excel.
Life is full of conditions and decisions. The same option in Excel is fulfilled by the IF FUNCTION.
In this section, let us try to use IF with the TEXT and try to solve many problems.
The learning is best using the examples, so we will learn by discussing the examples.
Let us start with the simple example.
Suppose we have two columns. One column is having the values as YES and NO.
We will put the value PASS if the first column contains YES otherwise NO.
We have to take the decision using the IF and checking the presence of TEXT in the first column.
STEPS TO USE IF FOR TEXT AND TAKE DECISION:
TEXT ALWAYS GOES INSIDE “”. IF TEXT IS NOT INSIDE THE INVERTED COMMAS , IT’LL CREATE AN ERROR.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE