Hi Arvi,

what happens if they are more than 24 conditions?


On 2004-12-10 01:19:00 -0500, "Arvi Laanemets" said:

Hi

When there are 24 or less conditions, then
=CHOOSE(MAX(CEILING(A1,1),4)-3,4.25,5.35,6.15,...,##.##)

When you prefer an editable price table, or when there number of prices is
24, then enter those prices into some range in ascending order, like this:
4.25
5.35
6.15
...
##.##

Further you can refer to this price table directly, or you can define a
named range p.e. PriceList

The formula will be
=INDEX(PriceList;MAX(CEILING(A1,1),4)-3,0)