Results 1 to 2 of 2

2.5 Incremental formula needed

Threaded View

  1. #1
    Registered User
    Join Date
    08-03-2010
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2003
    Posts
    1

    Exclamation 2.5 Incremental formula needed

    Thanks in advance for your help!!!


    I have this formula:

    C10=C1*H6/100

    Actual example is
    =54*65/100

    And I get 35.1

    I want to add this function to the statement

    The answer has to be within an increment of 2.5 and rounded up/down to whatever was closer.

    So 35.1 would be round down to 35 and show 35 and not 35.1

    Increments are like this, so anything in between these numbers would have to show the answer as one of these:
    30, 32.5, 35, 37.5, 40

    So if I got 35.5, if would be 35 that would show
    36 would be 35
    36.5 would be 37.5

    30 range is just an example, so I would like a formula that goes from 0-100.

    thank you!
    Last edited by usagis; 08-03-2010 at 07:43 PM. Reason: Title is not appropriate

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