How to set up a formula with two false values?

C

Chris

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?
 
R

Ron Coderre

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
 
B

Biff

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
 
Top