IF function is a very useful and most widely used conditional function in excel this function is used to give a result based on certain criteria. Write an IF statement so that if the number in Cell A2 is less than 100 the formula displays the text Within budget otherwise the formula displays the text. Excel Logic functions explained.
They help deal with different situations accordingly.
Excel IF Function The logical functions in Excel are a small group consisting of six functions These functions are noted for their black-or-white results A logical function can return only one of two values. If And in excel are the two most different functions which are usually nested together in a simple If function we can only test a single criteria but if we use the logical AND function we can test more than one criteria and give output based on the criteria they are used as follows IF Condition 1 AND Condition 2 Value if true Value if False. The functions are AND OR XOR and NOT. Visit our page about the OR function for many more examples.