Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Need help with a formula (I think?)

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Wheeling, WV
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    We are attempting to streamline our scheduling with formulating estimated calls into a spreadsheet(cheap company won't buy me scheduling software). What I am wanting to do is to take my orders * 1.5 which I got that far. Now I want to take the result and have it enter a value for instance if I have 24 orders * 1.5 would be 38 estimated calls and then pick a value like listed below

    so something like if x is <0 but >/=25 then 02, if <26 but >=100 then 07

    calls people needed
    0-25 02
    26-100 07
    101-150 09
    151-200 11

    Am I wishing for the impossible or can this happen?

    Thanks,
    Char


  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,310
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey there,

    I guessing your best bet is the use of a nested if-statement or a vlookup. If I understood your question correctly, the IF approach would give you a formula like:

    =IF(A2*1.5<26,2,IF(A2*1.5<101,7,IF(A2*1.5<151,9,11)))

    You may need to adjust the formula for entries of end values >200.

    The other approach involves writing out that table somewhere and using a VLOOKUP to reference it.

    Hope that helps,
    Adam

  3. #3
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I don't fully understand your request, but try the following (assumes A1 is the cell containing the value to test).

    =IF(A1>150,11,IF(A1>100,9,IF(A1>25,7,2)))


  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    Wheeling, WV
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the idea there.. I checked out the VLOOKUP and here is what I have and it's working now.

    =VLOOKUP(C6,PEOPLE,2)

    this is perfect.

    Thanks to all!

    Char

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •