Need Help Writing a Formula with Multiple IF/ OR Statements.

Hey everyone,

I've been trying to create a table for work to help with conversions and calculations and i was wondering how i should approach this formula.

I need to make a formula which will find the area and volume of a vertical or horizontal cylindrical AST and/or a rectangular AST dependent on which variables are present instead of having separate columns for the width diameter and circumference. (ex.) If the circumference of the cylinder is applied while the width and diameter are not present then calculate the volume of the cylinder using the circumference and length, or if the length is not present but the height is then to use the height instead of the length to do the calculation. It would also be helpful to find a formula to use in the same regard to find the area.

Here is an example of what my table looks like,

Attachment 275473

If any of you could please assist me with this it would be greatly appreciated.

Thanks guys,