Results 1 to 13 of 13

Using roundup in a column.

Threaded View

  1. #1
    Registered User
    Join Date
    05-03-2013
    Location
    California
    MS-Off Ver
    Excel 2011
    Posts
    7

    Using roundup in a column.

    Hi I've been breaking my head all morning trying to figure out how I can divide by a constant number, that being 200, in a column but also having it round off to only 2 decimals. I've been using =ROUNDUP(????/200,2) (the number changes in every column) Thats been working for me, BUT I'd like to know if there was a formula where I can just enter the number & have it it roundup & dived without having to put in the formula for every cell in the column. Your help is very much appreciated. Hope you guys can help.
    Attached Files Attached Files
    Last edited by NANCY55; 05-03-2013 at 04:25 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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