+ Reply to Thread
Results 1 to 2 of 2

If Statment range

  1. #1
    Registered User
    Join Date
    04-21-2007
    Posts
    1

    If Statment range

    Hello this is my first post, I have found this forum a great help.

    I have an input value and I need to categorise it into one of six categories.
    I am unsure how to address the range of each row.
    If Input value is between zero and 160,000 then display Size 1 and so on for all six ranges.
    Your assistance is greatly appreciated.

    Input Minimum Value Maximum Value Response
    87,343 160,000 399,999 Size 1
    400,000 800,000 Size 2
    800,001 2,200,000 Size 3
    2,200,001 6,00,000 Size 4
    6,000,001 54,999,999 Size 5
    55,000,000 Size 6

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,493
    download a sample scenarios workbook

    http://www.ozgrid.com/download/scenarios.zip


    here is a place for commisions


    http://www.aspdownload.com/read/?art=61

+ 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