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" wrote in message
...
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?