Results 1 to 7 of 7

Need a formula for a sliding scale

Threaded View

  1. #1
    Registered User
    Join Date
    06-18-2010
    Location
    Orange Park, FL
    MS-Off Ver
    Office 365
    Posts
    78

    Need a formula for a sliding scale

    On Sheet "Current" in Column K I need it to say (K5)
    if J5<>"DOM",J5
    if it does equal "DOM" then if the total volume (Column G) of Port 1 (Column J) for DOM is < 100 then DOM1
    if the total volume (Column G) of Port 1 (Column J) for DOM is 100 to <250 then DOM2
    if the total volume (Column G) of Port 1 (Column J) for DOM is 250 to <500 then DOM3
    if the total volume (Column G) of Port 1 (Column J) for DOM is 500 or > then DOM4

    I know this should be fairly easy, but I can't figure it out.

    Thank you
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sliding scale formula needed
    By kewl_jules in forum Excel General
    Replies: 8
    Last Post: 10-26-2012, 09:20 PM
  2. Formula for a sliding scale fee
    By trevorchorn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2012, 05:22 PM
  3. [SOLVED] Unequal Sliding Scale Formula
    By Aclowntant in forum Excel General
    Replies: 1
    Last Post: 04-18-2012, 12:57 PM
  4. Sliding scale formula
    By vbidiot in forum Excel General
    Replies: 7
    Last Post: 07-11-2011, 10:21 AM
  5. Need help with sliding scale compensation formula
    By goosebug in forum Excel General
    Replies: 1
    Last Post: 06-22-2011, 02:40 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