Question about Computers & Internet

1 Answer

Rounding off numbers

Hello,
I would like to know how to round off an number in microsoft 2007 excel

Example question: select and insert the worksheet function that will round off a number (either rounding up or down) to a specified number of digits.
Thanks,
FPH

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 849 Answers

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

Posted on Nov 04, 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:

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet


Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    Tip

    How to find no. of rows and columns in Worksheet.


    Hello everybody, this would be my first tip on FixYa.com. Number of people might not be aware how many rows and columns are there in Microsoft Worksheet.
    This is how you can find out.
    1. Select A1 cell in the worksheet
    2. Now press Ctrl + down arrow from your keyboard, that will take you to the bottom of the row. You can find the number on the left side.
    3. Again select A1 cell in the worksheet and press Ctrl + left arrow from your keyboard, that will take you to the last column of the worksheet. Now to number, just type "=column() " , without quotations, that will give you the number of the column.
    Microsoft Worksheet columns is number from A to Z, again from AA to AZ, again from BA to BZ and so on till it reached IV in Excell 2003 and earlier version.
    Microsoft Excel 2003 and old version has 16,777,216 cells per worksheet (65,536 rows * 256 columns).
    Excel 2007 has 17,179,869,184 cells per worksheet (1,048,576 rows * 16,384 columns).


    on Jul 27, 2010 | Microsoft Excel for PC

    1 Answer

    Describe the each part of microsoft excel 2207


    anmolsxn_0.gif
    Parts of the Excel 2007 Screen

    Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
    Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
    Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
    Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
    Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
    Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
    Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
    Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
    Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
    Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

    Nov 15, 2010 | Microsoft Windows XP Professional

    1 Answer

    Ms excel


    In Excel Worksheet 2007 the maximum number of rows per worksheet is 1,048,576 and the no. of cols. is 16,384 which is col. XFD, which makes it 17,179,869,184 cells.

    Jul 26, 2010 | Microsoft Windows Vista Ultimate Edition

    2 Answers

    VB 6.0 ROUNDING A NUMBER


    Use the Math.Round() function. It takes two arguments, the first is your number or a variable holding your number and the second is the number of decimal places. This will only round to fractions of a whole number though and you need to round to the nearest 10. So divide your number by 10 before you round to shift the decimal place once to the left and multiply by 10 again afterwards to shift it back again.

    answer = Math.Round(32.1 / 10, 0) * 10

    Apr 02, 2009 | Microsoft Visual Basic 6.0 for PC

    1 Answer

    How to copy Excel worksheet in a word document?


    go to Insert > File >select file and insert.
    you have to select all documents when you when insert box opens.

    Mar 15, 2009 | Microsoft Excel for PC

    2 Answers

    I Have list of numbers in coloumn in a sheet & i want its uniqe record in another sheet how it to do?


    You can use some add in for Excell, can be found much of them on internet. Or follow this instruction: http://www.cpearson.com/excel/Duplicates.aspx for any brainstorming :)

    Mar 11, 2009 | Microsoft Computers & Internet

    1 Answer

    Rounding Off numbers to the nearest tens


    is it helpful or not plz reply me and ask me syntax i m intersted in solving problem like this bcoz through it i get refreshed in C languge.
    u can send me a query on my email akhilgnit @gmail.com
    thnx

    Feb 07, 2009 | Microsoft Visual Basic 6.0 for PC

    1 Answer

    Rounding Time in Excel 2007


    format the cells that contains times and net time worked as time format you using Enter the simple formula   =if(c14<=0,Int(0),(c14-c13))

    Feb 04, 2009 | Microsoft Excel for PC

    2 Answers

    Can't reopen circular reference file in excel


    1. Click the Microsoft Office Button , click Excel Options, and then click the Formulas category.
    2. In the Calculation options section, select the Enable iterative calculation check box.
    3. To set the maximum number of times that Excel will recalculate, type the number of iterations in the Maximum Iterations box. The higher the number of iterations, the more time that Excel needs to calculate a worksheet.
    4. To set the maximum amount of change you will accept between calculation results, type the amount in the Maximum Change box. The smaller the number, the more accurate the result and the more time that Excel needs to calculate a worksheet.

    Nov 05, 2008 | Microsoft Excel for PC

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

    Related Topics:

    421 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...