Want this question answered?
Um
It is not possible to have any numbers lying between ONE number.
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.
The odd numbers between these values are 49, 51, 53, 55, 57 and 59.
There are an infinite number of decimal values between any two numbers. 5.01, 5.1, 5.999999 are examples.
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
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
The average is the ratio between the sum of these values and the number of values.
Um
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.
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.
The odd numbers between these values are 49, 51, 53, 55, 57 and 59.
There are an infinite number of decimal values between any two numbers. 5.01, 5.1, 5.999999 are examples.