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

forum.ozgrid.com/index.php?attachment/38173/

**Important Notice**

We will be implementing some important changes during 25th and 26th May 2024 which may result in an outage period of the website. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!