i have 7 ranges of
150-270,270-600,550-1000,1000-1600,1300-1900,550-2640,650-3120 Each range
comes with a price of cost and manhours. I need a formula so that when I
enter a number it will select for me the correct range and then give me the
cost and labor price of that range. For a smaller selection I would have
used if but with 7 it doesn't work. Any help would be appreciated
Thanks