if/and formula

<tbody> TABLE 1 Widget --Length of Widget-- --SF of Widget-- $$COST$$ </tbody> <tbody> TABLE 2 --Length of Widget-- $$COST$$ 0-5 Feet $10 6-10 Feet $15 </tbody> I need to create a formula that will calculate the cost in TABLE 1 assuming a minimum for the --SF of Widget--...

I have a scoring matrix for a number of services. Each service has its own RAG status. Example below. <tbody> Minutes <30 30-59 60-89 90-119 120-149 150-179 1 2 3 4 5 6 Serv1 3 3 6 9 12 15 18 Serv2 3 3 6 9 12 15 18 Serv3 2 2 4 6 8 10 12 Serv4 1 1 2 3 4 5 6 </tbody> I...