View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NTWyatt
 
Posts: n/a
Default Need an advanced "if" function: if 2<x<2.9 then y, if 3<x<3.9 then

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!