+ Reply to Thread
Results 1 to 3 of 3

Round Up Function

  1. #1
    Registered User
    Join Date
    10-26-2017
    Location
    US
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    2

    Round Up Function

    Hi all,

    I am trying to do the roundup function to the following formula, but I can't get it to work.

    =(AH19*0.15)+AH19

    I am trying to get the amount to round from $1891.75 to 1892.00.

    How do I correctly do the formula?

    Thanks in advance.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Round Up Function

    Try like this:

    =ROUNDUP(AH19*1.15,0)
    Audere est facere

  3. #3
    Registered User
    Join Date
    10-26-2017
    Location
    US
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    2

    Re: Round Up Function

    You made that look easy! Worked perfectly, thank you SO much for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] If Statement with a Divisible-By function and Round Function
    By thanhie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-06-2013, 01:00 AM
  2. [SOLVED] Conditional Round up or Round up Function
    By cdmterence in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-18-2013, 06:03 PM
  3. Problem Inserting Round function into an IF function
    By Ash87 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-11-2013, 05:37 PM
  4. Help with ROUND Function
    By LuckyMan in forum Excel General
    Replies: 4
    Last Post: 05-22-2012, 09:51 AM
  5. Help with VBA Round() function please
    By KurtKeilbach in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2009, 04:51 PM
  6. VB Function Round vs Excel function Round not behaving the same Od
    By Bud in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-18-2006, 12:45 AM
  7. [SOLVED] Round function
    By R Marko in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-09-2006, 11:40 AM
  8. The ROUND function
    By Louise in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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