How to set up a formula with two false values?

I need to set up of a formula with this info:
1-5 pcs =$5, 6-10=$7, 11-15 = $10. I use the "IF" format, but I can't
figure it out. Can anyone help?

Maybe one of these?:

For a value in A1

B1: =CHOOSE(INT((A1-1)/5)+1,5,7,10)
or
B1: =VLOOKUP(A1,{0,5;6,7;11,10},2,1)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Chris" wrote:

> I need to set up of a formula with this info:
> 1-5 pcs =$5, 6-10=$7, 11-15 = $10. I use the "IF" format, but I can't
> figure it out. Can anyone help?

Hi!

Try this:

A1 = some number

=LOOKUP(A1,{0;1;6;11},{"";5;7;10})

If A1 is empty or 0 the formula returns a blank. If A1 >15 the formula
returns 10.

Biff

"Chris" <[email protected]> wrote in message
news:[email protected]...
>I need to set up of a formula with this info:
> 1-5 pcs =$5, 6-10=$7, 11-15 = $10. I use the "IF" format, but I can't
> figure it out. Can anyone help?

WOW!!! The second forumual worked!!! Thank you so much for you help!!!!!

"Ron Coderre" wrote:

> Maybe one of these?:
>
> For a value in A1
>
> B1: =CHOOSE(INT((A1-1)/5)+1,5,7,10)
> or
> B1: =VLOOKUP(A1,{0,5;6,7;11,10},2,1)
>
> Is that something you can work with?
> ***********
> Regards,
> Ron
>
> XL2002, WinXP
>
>
> "Chris" wrote:
>
> > I need to set up of a formula with this info:
> > 1-5 pcs =$5, 6-10=$7, 11-15 = $10. I use the "IF" format, but I can't
> > figure it out. Can anyone help?