IF functions are very useful for performing logic, and they vary from simple to complex.
For example, Amazon believes that if the stock level of mobile phones is less than 50, an order should be placed to bring the stock level back to 200. If the stock level is above 50 units, no action shall be taken.
Download the file here.
Download the file here.
Enter the formula =IF(condition,Value_IF_True,Value_IF_False), where condition is any condition that is either true or false, Value_IF_True is the value of the formula if the condition is true, and Value_IF_False is the value of the formula if the condition is false.
What this means is that If the condition mentioned is true, the formula will return Value_IF_False, if false, it will return Value_IF_False
A simple example is =IF(A1<5,10,“NA”).
In the above example, IF the value of A1<5, the formula will return the value 10, if false - it will return the value NA.
Note that if either of the expressions is a label or text (as opposed to a numeric value), it should be enclosed in double quotes.
Understand how to format your Excel sheet in few easy steps: http://learnexceleasily.blogspot.in//2013/11/quick-formatting-and-beautification.html
Please share your feedback here.
