How can I solve this question in Excel? $8$ Finding the Volume of a Storage Bin I

A fairly common shape for a dry$-$solids storage bin is a cylindrical silo with a conical

collecting section at the base where the product is removed $($see Figure $60.)$

To calculate the volume of the contents, you use the formula for a cone, as long as

the height of product, $h,$ is less than the height of the conical section, $h_{\text{c}\text{o}\text{n}\text{e}}$ :

$r_{h}hh{r}_h=h_{\text{c}\text{o}\text{n}\text{e}}tan().V=\frac{1}{3}{R}^2{h}_{\text{c}\text{o}\text{n}\text{e}}+R^2(h-h_{\text{c}\text{o}\text{n}\text{e}}),ifh>h_{\text{c}\text{o}\text{n}\text{e}}\mathrm{.}2mV=\frac{1}{3}{r}_h^{2}h,ifh$

Here, $r_{h}is$ the radius $at$ height $h$ and can $be$ calculated from $hby$ using trigonometry:

$r_h=h_{\text{c}\text{o}\text{n}\text{e}}tan().$

Excel Functions

$If$ the height $of$ the stored product $is$ greater than the height $of$ the conical section,

the equation for a cylinder must $be$ added $to$ the volume $of$ the cone:

$V=\frac{1}{3}{R}^2{h}_{\text{c}\text{o}\text{n}\text{e}}+R^2(h-h_{\text{c}\text{o}\text{n}\text{e}}),ifh>h_{\text{c}\text{o}\text{n}\text{e}}.$

$If$ the height $of$ the conical section $is3$ meters, the radius $of$ the cylindrical section

$is2m,$ and the total height $of$ the storage bin $is10$ meters, what $is$ the maximum

volume $of$ material that can $be$ stored?