+ Reply to Thread
Results 1 to 3 of 3

round up or down

  1. #1
    lsmft
    Guest

    round up or down

    Is there a way to program a cell to automatically round a number up or down if the number being rounded is a sum of other numbers? I'd like to be able to round this $1.22 either up or down in $0.25 cent increments.

    Example:
    =sum($0.15+$1.07)=$1.22

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Assuming you are summing A1 & B1 try

    =ROUND(SUM(A1:B1)*4,0)/4

  3. #3
    lsmft
    Guest
    Quote Originally Posted by daddylonglegs
    Assuming you are summing A1 & B1 try

    =ROUND(SUM(A1:B1)*4,0)/4
    Thank you much,
    Works just fine.

+ Reply to Thread

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