I am working on creating an Effort Estimate Tool for Clients.
I have 5 products Affinity, Quantim, QES, Interlink and COPE. For each
product we have estimates. Example is stated below. Similar to this, we have
5 other products with estimates in the same way.

Interlink
Estimations for
Severity RN User Guide

Low 1 hour 2 hours
Medium 2 hours 3 hours
High 3 hours 4 hours

I have created a table which has drop downs to chose the product, Severity,
Type of Document. Now based on the selection made, i want the number of
defects to multiple with the estimates provied in the respective product
table.

For Ex: If i select Interlink as a product and say Medium severity 10
Defects for RN document, it has to return 20 hrs as an estimate.

Is this possible with one formula? I am fine if we can split this to a
couple of steps also. Pls suggest.

Regards,
Sri Harsha.

Sri Harsha,

See http://www.contextures.com/xlFunctions03.html for ideas and required
formulas.

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Sri Harsha" wrote:

I am working on creating an Effort Estimate Tool for Clients.
I have 5 products Affinity, Quantim, QES, Interlink and COPE. For each
product we have estimates. Example is stated below. Similar to this, we have
5 other products with estimates in the same way.

Interlink
Estimations for
Severity RN User Guide

Low 1 hour 2 hours
Medium 2 hours 3 hours
High 3 hours 4 hours

I have created a table which has drop downs to chose the product, Severity,
Type of Document. Now based on the selection made, i want the number of
defects to multiple with the estimates provied in the respective product
table.

For Ex: If i select Interlink as a product and say Medium severity 10
Defects for RN document, it has to return 20 hrs as an estimate.

Is this possible with one formula? I am fine if we can split this to a
couple of steps also. Pls suggest.

Regards,
Sri Harsha.