Question about Computers & Internet

1 Answer

About rounding off whole numbers in excel

43,324,598 and if your going to round off this number, the result would be 43 000 000
4,345,855 the result would be 4,000,000

Hope you can help me..
Tnx.

Posted by on

1 Answer

Jhlhlhlh

Posted on Oct 16, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

What is 5.375 rounded to the nearest whole number?


5.375 rounded to the nearest whole number is five (5).

Feb 19, 2015 | Office Equipment & Supplies

1 Answer

How do I round a formula result in the same cell?


Did you ever try round? or press F1 for help on this?

Oct 30, 2014 | Microsoft Excel X for Mac

2 Answers

Round 12,3478.561 to whole number


Rounded to a whole number, it's 12,3479.

Oct 16, 2013 | Office Equipment & Supplies

2 Answers

What is 229,930 rounded to in whole numbers?


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.

Oct 03, 2013 | The Learning Company Achieve! Math &...

1 Answer

How to find remainder as a solution in CASIO fx991ES


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.

Dec 16, 2012 | Casio FX991ES Scientific Calculator

1 Answer

I need help with an excel formula. I am looking to get to a retail price, knowing the cost and the margin. For example, the cost is $10.00, margin is 25%, so my formula would be =10/75%. The total would be...


=INT(A1)+0.95

With A1 being the reference to the cell you wish to round up
What that does is first round down the number to a whole one then adds 0.95 to the figure

Hope this gives you the information you need

Bob
Moderator

It would be very decent of you to consider the quality of our expert’s answers and judge them accordingly as you pass through FixYa.

Thank you

Mar 17, 2010 | Microsoft Excel 2003 (065-03992) for PC

3 Answers

How to round the fig. in Excel 2007 E.g. 12350*32.75% = 4044.625 I want it to be rounded to nearer rupee. If the decimal is lesser than 50, rounded fig. should be lower Rupee if the decimal is more than 50...


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: ROUND(number,num_digits) The number you want to round. None. num_digits The 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. -Ken

Aug 29, 2009 | Microsoft Office Excel 2007

1 Answer

Excel 07 truncuating problem


You need to use the ROUND function.
E.g. type: =ROUND(A1,2)*A2

Assuming the 2.131576 is in cell A1 and 1000 is in A2.
The round function round the value to 2 decimals (in this case because I specified 2 as the second argument).


May 06, 2009 | Keystone Excel 2007 Essentials for PC...

1 Answer

Rounding off numbers


check the standard tool bar, increase decimal places/decrease decimal places tool will solve your problem.

Nov 04, 2008 | Computers & Internet

1 Answer

Excel


suppose ur number is at cell B2 with any value. lets say u want formula in A3. then A3 =*b2*3/4 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.

Sep 17, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

625 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...