Calculation based on three different criterias

[zvladk]

Hi everyone,
I have ran into some trouble with my formula to calculate the total weight of a certain item in my cost estimator worksheet.

I have attached a file and the formula that I'm having issues with is Column I (Weight)..

What I would like the formula to do is calculate the weight based on three different criterias..

1) If Columns B & C are blank I would like Column I to Display a "0". (which it does right now)

2) If Columns B & C are found in my Weight Tab then it needs to calculate the total weight in Column I. (which it also does right now)

3) If Columns B & C are not found in my Weights Tab and are not blank to still do the calculation as weight/ft and Net Cost are entered into the worksheet...


The reason for the 3rd criteria is its almost impossible to enter all types of sizes for some of the items
that we work with (very rare items that are abnormal sizes) so if something is entered that is rare i still need the calculation to happen.

Thank you for your help on this in advance..
Hope that this is possible,

Vlad

[watersev]

hi, zvladk, hope this helps

[zvladk]

Great... Exactly what I was looking for.

Thank you very kindly,
Vlad