Drop Down Box Choice Selects Volume Function

[Tony Pass]

I am in building trades and often have to calculate the volume of every room in a house. I was trying to set up a table of length ,width, height and diameter. A drop down box would indicate the shape , rectangle , triangle, circle.

Upon choosing the shape it would then calculate the volume by its appropriate formula and then post it in the volume column. Tried If Then to no success, any help out there.
Thanks in Advance, Tony Pass

[protonLeah]

Please Login or Register  to view this content.

[ratcat]

G'day and welcome to the forum,

I think I might have a solution. Firstly can you please supply example of your workbook to see if it works with your layout.

Cheers

Edit: After seeing protonLeah post

Challenge solved.

[Tony Pass]

Thanks for offer http://www.excelforum.com/images/smilies/smile.gif

[Tony Pass]

Thanks I tried to make it far more difficult.