Hi

=CHOOSE(MATCH(A1,{0;3.5;4;4.5;5;5.5;6},1),0.04,0.0 45,0.05,0.055,0.6)
, or
=0.04+0.005*INT(2*MIN(MAX(A1,3),6)-3)


Arvi Laanemets


"NTWyatt" wrote in message
...
Hi there - I need help with getting a formula (single cell if possible)
that
will apply the following table:

Less than 3.5 to 1.00
Level I 4%
Less than 4.0 to 1.00, but greater than or equal to 3.5 to 1.00 Level
II
4.5%
Less than 5.0 to 1.00, but greater than or equal to 4.0 to 1.00 Level
III 5%
Less than 6.0 to 1.00, but greater than or equal to 5.0 to 1.00 Level
IV
5.5%
Greater than 6.0 to 1.00
Level V 6%

Thanks in advance!