Returns the odd number after rounding the specified number up.
Syntax
ODD(number)
Number is the number that will be rounded.
Description
• If Number is a non-numeric parameter, function ODD will return the error value #VALUE!.
• Regardless of the sign, the value is Rounds away from 0. If Number happens to be an odd number, no rounding is necessary.
The main part of the ODD function Its function is to round up a non-odd number to the nearest odd number.
This function is common when voting. Suppose that in a competition to determine the first and second place based on the voting results, at least 1/2 of the students in each class are requiredParticipate.
At the same time, in order for the voting to have results, it must be ensured that the number of voters is an odd number. Knowing the total number of people in each class, calculate the minimum number of people in each class to participate in voting.
Next, I will show you the specific steps to use this function.
■ Select cell B2, click Insert Function, find the ODD function, and click OK.
A dialog box will pop up with one parameter.
Value: Indicates the value to be rounded.
We fill in A2/2 in the value and click OK.
Position the cursor to the lower right corner of cell B2 and pull down to fill in the cell when it forms a + shape to find the minimum number of participants in each class.
评论列表(196条)
测试