The nearest value of (1-.01)into.01
Answers
Answer:
round up values to the right of the decimal point, use a positive number for digits:
=ROUNDUP(A1,1) // Round up to 1 decimal place
=ROUNDUP(A1,2) // Round up to 2 decimal places
=ROUNDUP(A1,3) // Round up to 3 decimal places
=ROUNDUP(A1,4) // Round up to 4 decimal places
Example #2 - round to left
To round up values to the left of the decimal point, use zero or a negative number for digits:
=ROUNDUP(A1,0) // Round up to nearest whole number
=ROUNDUP(A1,-1) // Round up to nearest 10
=ROUNDUP(A1,-2) // Round up to nearest 100
=ROUNDUP(A1,-3) // Round up to nearest 1000
=ROUNDUP(A1,-4) // Round up to nearest 10000
Example #3 - nesting
Other operations and functions can be nested inside ROUNDOWN. For example, to round the result of A1 divided by B1, you can use a formula like this:
=ROUNDUP(A1/B1,0) // round up result to nearest whole number
Rounding functions in Excel
To round normally, use the ROUND function.
To round to the nearest multiple, use the MROUND function.
To round down to the nearest specified place, use the ROUNDDOWN function.
To round down to the nearest specified multiple, use the FLOOR function.
To round up to the nearest specified place, use the ROUNDUP function.
To round up to the nearest specified multiple, use the CEILING function.
To round down and return an integer only, use the INT function.
To truncate decimal places, use the TRUNC function.
ROUNDUP formula examples
Excel formula: Get quarter from date
Get quarter from date
In this case, the formula first extracts the month as a number between 1-12, then divides this number by 3. The result is then rounded up to the nearest whole number using the ROUNDUP function. The ROUNDUP function...
Excel formula: Round a number up
Round a number up
The ROUNDUP function rounds a number up to a given number of places. The number of places is controlled by the number of digits provided in the second argument (num_digits). For example, these formulas round the number...
Excel formula: Count with repeating values
Count with repeating values
The core of this formula is the ROUNDUP function. The ROUNDUP function works like the ROUND function except that when rounding, the ROUNDUP function will always round the numbers 1-9 up. In this formula, we use that...
Excel formula: Randomly assign people to groups
Randomly assign people to groups
At the core of this solution is the RAND function, which is used to generate a random number in a helper column (column C in the example). To assign a full set of random values in one step, select the range C5:C16,...
Answer:
Hlo dear.....
Plz follow me and thank to my answers ......
I will do this same.........
Have a great day..............