+ Reply to Thread
Results 1 to 2 of 2

How do I use a rounded calculation result in another calculation?

  1. #1
    vnsrod2000
    Guest

    How do I use a rounded calculation result in another calculation?

    Calculation A
    I am finding a percent score, but I want it rounded to the nearest percent.
    For example, I want the following result to display as 88%:
    (35/40)=87.5%

    I know the result is displayed as 88%, but I want to use the actual rounded
    result (88%) in Calculation B.

    Calculation B
    What I want is .88*1500=1320
    What I get is .88*1500=1313
    Help!

  2. #2
    N Harkawat
    Guest

    Re: How do I use a rounded calculation result in another calculation?

    =ROUNDUP(35/40,2)

    "vnsrod2000" <vnsrod2000@discussions.microsoft.com> wrote in message
    news:7CE8F560-C0F8-45CA-A5F3-6A5AA85622BF@microsoft.com...
    > Calculation A
    > I am finding a percent score, but I want it rounded to the nearest
    > percent.
    > For example, I want the following result to display as 88%:
    > (35/40)=87.5%
    >
    > I know the result is displayed as 88%, but I want to use the actual
    > rounded
    > result (88%) in Calculation B.
    >
    > Calculation B
    > What I want is .88*1500=1320
    > What I get is .88*1500=1313
    > Help!




+ 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