Results 1 to 2 of 2

Adjustments required in a previously answered formula request regarding % increases

Threaded View

  1. #1
    Registered User
    Join Date
    01-10-2014
    Location
    Bristol, England
    MS-Off Ver
    Excel 2013
    Posts
    28

    Adjustments required in a previously answered formula request regarding % increases

    Some time ago, I was helped with the following statement. It increased in £50 increments between between the 6-10% value field

    =250*((H27-E27)/E27>=5.5%)+MIN(((H27-E27)/E27>=5.5%)*INT(100*((H27-E27)/E27-5.5%))*50,200)

    I need to change that vale so that rather than it increasing by £50 at every single 1% increase it now needs to increase at every 1.5% increase.

    before was 6%, 7%, 8%, 9% & 10%

    It now needs to be 8%, 9.5%, 11%, 12.5% & 14%
    Last edited by Nick1966; 01-06-2018 at 07:40 AM. Reason: Incorrect Title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  2. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  3. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  4. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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