The IF function is one of the most used functions in Excel. It will return TRUE if at least any one of the arguments or conditions evaluates as TRUE. 1 Count and Sum.
The most used functions in Excel are the functions that count and sum.
You sell a certain for the highest price of 50 and a certain for the lower price of 20. The IF function can be combined with logical functions like AND and OR to extend the logical test. For example if condition A is met then the value should be B and if the condition is not met the value should be C this function takes three arguments the first argument is the criteria while the second argument is the result when the condition is true and third argument is when the condition is false. AND function in Excel is categorized as a logical function.