Um
It is not possible to have any numbers lying between ONE number.
There are an infinite number of decimal values between any two numbers. 5.01, 5.1, 5.999999 are examples.
The odd numbers between these values are 49, 51, 53, 55, 57 and 59.
The range of a set of numbers is the difference between the highest and lowest values. Find these and subtract the lowest from the highest.
By creating Data validation rules you should be able to restrict the values of data entered
The Settings tab under the menu Data -> Filter -> Advanced Filter
Three types of data may be entered into a spreadsheet or worksheet: (1) values or numbers, (2) names or labels, and (3) formulas for calculation.
we can determine that by subtracting the two numbers
In a spreadsheet, numbers are referred to as "values." These values can be entered into individual cells and used in calculations, formulas, and functions within the spreadsheet software. It is important to format numbers correctly in order to display them accurately and perform calculations accurately.
There are infinitely many numbers between 2567 and 2756 if the type of numbers is not specified. For instance... 2568, 2567.7, 2768.33409340293.... are the numbers between these values
Um
The average is the ratio between the sum of these values and the number of values.
It is not possible to have any numbers lying between ONE number.
Validation allows you to limit what goes into cells. By applying validation you can do things like put an lower and upper limit on numbers entered into a cell, like allow only values between 1 to 100. You can also use it to highlight cells that already have values that are not valid, by applying validation and getting Excel to draw red ovals around the ones that are invalid. This can help you find errors in values that have already been entered. Validation allows you prompt the user to tell them what can be entered and also give them a message to tell them what they have done wrong.
There are an infinite number of decimal values between any two numbers. 5.01, 5.1, 5.999999 are examples.
The odd numbers between these values are 49, 51, 53, 55, 57 and 59.