Need help with a formula (I think?)

[twistedchickie]

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

[Asala42]

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

[Jay Petrulis]

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)))

[twistedchickie]

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