Hi again,
Try this formula in cell B7 (this should work for both "smooth" and "resi"):
Formula:
=IF(B2="smooth",((B4/2)^2)*PI()*B3,IF(B2="resi",((B4/2)^2)*PI()*(B3*2),""))
or alternatively use:
Formula:
=((B4/2)^2)*PI()*B3*IF(B2="smooth",1,IF(B2="resi",2,0))
Both of these formulae will produce the same output, it is simply up to you which one you choose to use.
Hope this helps
P.S. If this is the solution that you were after, please don't forget to mark this thread as solved and click on the * next to my post to say thanks
Bookmarks