conditional formula?

[Justin]

Cell D10 is a formula which shows me packages per stop. Cells R10 thru U10
are formulas which show me expected Stops per hour based on an increasing
number of pacakges per stop. Cell G10 is a manual entry made by me (cutting
and pasting value and number format from the appropriate R10-U10 row. I would
like to know if there is a formula I can use so that the entry in G10 is
automatic?

Something like,

IF D10 (packages per stop) is greater than 1 and less than 5, cell G10
(expected stops per hour = R10. If D10 is greater than 6 and less than 10,
G10 = S10. If D10 is greater than 11 and less than 15, G10=U10.

thanks!

[Dave Peterson]

I think...

=if(and(d10>1,d10<5),r10,if(and(d10>6,D10<10),s10,
if(and(d10>11,d10<15),u10,"whatgoeshere")))
(all one cell)

Or maybe...
=if(d10>10,u10,if(d10>5,S10,r10)))


Justin wrote:
>
> Cell D10 is a formula which shows me packages per stop. Cells R10 thru U10
> are formulas which show me expected Stops per hour based on an increasing
> number of pacakges per stop. Cell G10 is a manual entry made by me (cutting
> and pasting value and number format from the appropriate R10-U10 row. I would
> like to know if there is a formula I can use so that the entry in G10 is
> automatic?
>
> Something like,
>
> IF D10 (packages per stop) is greater than 1 and less than 5, cell G10
> (expected stops per hour = R10. If D10 is greater than 6 and less than 10,
> G10 = S10. If D10 is greater than 11 and less than 15, G10=U10.
>
> thanks!

--

Dave Peterson

[Toppers]

=IF(AND(D10>1,D10<5),R10,IF(AND(D10>6,D10<10),S10,IF(AND(D10>11,D10<15),U10,"")))

"Justin" wrote:

>
> Cell D10 is a formula which shows me packages per stop. Cells R10 thru U10
> are formulas which show me expected Stops per hour based on an increasing
> number of pacakges per stop. Cell G10 is a manual entry made by me (cutting
> and pasting value and number format from the appropriate R10-U10 row. I would
> like to know if there is a formula I can use so that the entry in G10 is
> automatic?
>
> Something like,
>
> IF D10 (packages per stop) is greater than 1 and less than 5, cell G10
> (expected stops per hour = R10. If D10 is greater than 6 and less than 10,
> G10 = S10. If D10 is greater than 11 and less than 15, G10=U10.
>
> thanks!