- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
That depends on whether the comma is a digit separator or the radix mark. If it's a separator as in the US, the rounded number is 229,930. If it's a radix mark as in most of Europe, the rounded number is 230.
Finding the remainder from a division calculation is often referred to as using the MOD function, though this isn't available directly on the fx-991ES. To obtain the remainder, for example when dividing 10 by 7, you can only divide 7 into 10 once, leaving a remainder of 3. For
larger numbers, eg when dividing 389487 by 31 (equivalent to 389487MOD31) the division gives an answer of 12564.09677 (on the display), however you only want the
fractional part so subtract 12564 to give 0.0967741935 . This includes
the lower value digits that were previously hidden. Then multiply this
result by 31 which gives 2.999999999 on the display. Since the result
of a MOD or remainder calculation involving integers has to be a whole number, the answer needs to be
rounded to 3. If the answer doesn't easily round to a whole number, it
is likely that you have gone beyond the calculator's working capacity. An
alternative method which avoids the rounding of the fractional part is to take the integer part of the first result
(12564) and multiply it by 31 to get 389484, then subtract this from
389487, giving the answer of 3.
The function is called ROUND. It has 2 arguments, (1) the original number and (2) the number of decimal digits. Here is the Excel's help:
The number you want to round.
num_digitsThe number of digits to which you want to round number.
•If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
•If num_digits is 0, then number is rounded to the nearest integer.
•If num_digits is less than 0, then number is rounded to the left of the decimal point.
So for your case use this in a cell "=ROUND(12350*32.75%, 0)" without quotes, where I assume one or both numbers will come from other cells.
suppose ur number is at cell B2 with any value.
lets say u want formula in A3. then A3
to round back the A3 to full number the simpliest
solution is to change cell formatint to NUMBER and set the decimal places to 0.