Results 1 to 6 of 6

Can I make a cell round the value to the nearest whole number?

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2010
    Location
    West Virginia, USA
    MS-Off Ver
    Excel 2000
    Posts
    31

    Can I make a cell round the value to the nearest whole number?

    I have a cell that is going to be used for the quantity of a certain item. I would like to dummy proof this sheet as much as possible so that if someone puts in 21.5, that it will do something like change the value to either 21 or 22, since there can't really be a .5 of this item.
    Last edited by Garren1013; 12-10-2012 at 04:38 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1