There are many ways of doing this. Start the formula with an sign select a cell enter an operator like or then select another cell. Click Evaluate multiple times.
If we want to return more than one value use these formulas in Excel by selecting the range of cells as in example 2.
To test if a number in A1 is greater than zero and less than 10 use ANDA10A1. Count Formula in excel is used to count the numbers of data in a range of cells the condition to this formula is that this formula only counts the numbers and no other texts for example if we have a formula as Count 1 e 2 then the result displayed is 2 rather than three as the formula only counts the numbers. If we want to return a single value use these formulas in a single cell as in example 1. There are many ways of doing this.