0
In Excel how do you round a number to the thousands e.g. 28364 To 28000?
Bekahheifb1950
There is no direct function to do it, so you need to use a formula and put the result in another cell. If you divide the number by 1000 and get the integer value of the result and multiply it by 1000 that will do it. So, dividing 28364 by 1000 will give you 28.364. The integer part is the 28, so you then just multiply that by 1000 and it will give you 28000. Say the 28364 was in cell A2, then you could write a formula like this in another cell:
=INT(A2/1000)*1000
That will always round down, so even 28,999 would give you 28000. If you want to be able to round up and down as appropriate, then you need to check the value of the remainder when you divide by 1000 and if it is 500 or above, you need to add another 1000 or just add zero. That will make the formula more complex:
=INT(A2/1000)*1000+IF(MOD(A2,1000)>=500,1000,0)
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What are 8 formulas used in Excel?
There are thousands of formulas and more than a hundred functions used in Excel.
How many institutions use Excel?
It is impossible to know. All sorts of people, organisations, companies, institutions and other groupings use it. An exact record of who uses it would not be available. Around the world there would be a huge number of institutions of one sort or another that use Excel. So there would be thousands and thousands of them.It is impossible to know. All sorts of people, organisations, companies, institutions and other groupings use it. An exact record of who uses it would not be available. Around the world there would be a huge number of institutions of one sort or another that use Excel. So there would be thousands and thousands of them.It is impossible to know. All sorts of people, organisations, companies, institutions and other groupings use it. An exact record of who uses it would not be available. Around the world there would be a huge number of institutions of one sort or another that use Excel. So there would be thousands and thousands of them.It is impossible to know. All sorts of people, organisations, companies, institutions and other groupings use it. An exact record of who uses it would not be available. Around the world there would be a huge number of institutions of one sort or another that use Excel. So there would be thousands and thousands of them.It is impossible to know. All sorts of people, organisations, companies, institutions and other groupings use it. An exact record of who uses it would not be available. Around the world there would be a huge number of institutions of one sort or another that use Excel. So there would be thousands and thousands of them.It is impossible to know. All sorts of people, organisations, companies, institutions and other groupings use it. An exact record of who uses it would not be available. Around the world there would be a huge number of institutions of one sort or another that use Excel. So there would be thousands and thousands of them.It is impossible to know. All sorts of people, organisations, companies, institutions and other groupings use it. An exact record of who uses it would not be available. Around the world there would be a huge number of institutions of one sort or another that use Excel. So there would be thousands and thousands of them.It is impossible to know. All sorts of people, organisations, companies, institutions and other groupings use it. An exact record of who uses it would not be available. Around the world there would be a huge number of institutions of one sort or another that use Excel. So there would be thousands and thousands of them.It is impossible to know. All sorts of people, organisations, companies, institutions and other groupings use it. An exact record of who uses it would not be available. Around the world there would be a huge number of institutions of one sort or another that use Excel. So there would be thousands and thousands of them.It is impossible to know. All sorts of people, organisations, companies, institutions and other groupings use it. An exact record of who uses it would not be available. Around the world there would be a huge number of institutions of one sort or another that use Excel. So there would be thousands and thousands of them.It is impossible to know. All sorts of people, organisations, companies, institutions and other groupings use it. An exact record of who uses it would not be available. Around the world there would be a huge number of institutions of one sort or another that use Excel. So there would be thousands and thousands of them.
Total number of column in Microsoft Excel?
The total number of columns in versions of Excel up to Excel 2003 is 256 columns. The total number of columns in Microsoft Excel 2007 and onwards is 16384. The total number of rows up to Excel 2003 is 65536. From Excel 2007 it is 1048576.
What is the bottom number on Microsoft Excel?
The last row number for Excel 2007 is 1048576.
What is a number that can be entered into a cell on Excel?
Which of the following is a number that can be entered into a cell?
How does the trig function ACOS work in Excel?
In Excel, the ACos function returns the arccosine (in radians) of a number.The syntax for the ACos function is:ACos( number )number is a number between -1 and 1. It is the cosine of the angle that you wish to find.Applies To:Excel 2007, Excel 2003, Excel XP, Excel 2000
How do you say excel in native American language?
There is not just one Native American language, there are thousands of them.
Total number of formulas in Excel?
The amount of formulas that can be done in Excel is infinite.
How can you increase the number of columns in your Excel because the number of all columns is only 255?
Upgrade to Excel 2007 or higher. There is no way to increase the number of columns designed into the spreadsheet. Excel 2003 and earlier have a limit of 256 columns. Excel 2007 and higher has increased that to 16,000 columns.
How you enter account no in Excel sheet it not except?
This question is not clear. You can enter a number in Excel by clicking on a cell and typing the number from the keyboard.
Excel recognizes an entry as a value if it is a number or it begins with?
Excel recognizes an entry as a value if it is a number or it begins with one of these symbols: +, -, =, @,#, or $ Rina
How do you find scientific notation on excel?
You find scientific notation in Excel under the Format - Number menu.
