COUNTIF range criteria Click into any of the cells above your the first few columns and start on your formula by typing in a sign. 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. Returns the number of non-blanks in a supplied set of cells or values.
Returns the number of numerical values in a supplied set of cells or values.
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. Returns the number of non-blanks in a supplied set of cells or values. 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. You can use the AND OR NOT and IF functions to create conditional formulas.