+ Reply to Thread
Results 1 to 3 of 3

combining 2 formulas markup roundup

  1. #1
    Registered User
    Join Date
    05-22-2007
    Posts
    2

    combining 2 formulas markup roundup

    I am trying to merge two formulas without success. The formulas work independently not together. I want the result to display in E12 and I dont want to use two cells. Any help would be appreciated.

    =D12/(1-0.12),Roundup(E12,1) I want to markup d12 12% and display the result in e12 however i want the result to be rounded up to the next dollar amount.

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Try this:

    =ROUNDUP(D12/(1-0.12),0)

  3. #3
    Registered User
    Join Date
    05-22-2007
    Posts
    2

    thanks

    thank you it worked !

+ 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