???????Can you show how to do these questions in excel?
NESTED IF TUTORIAL 1. Question: 3. Question: If cell A1 is less than 20 , then multiply it by 1,2 If \( \mathrm{Cl}=0, \mathrm{H} \) is equal to \( \mathrm{A} 1 / 2 \) If it is greater than or equal to 20 but less than 50 , then multiply by 2 If \( \mathrm{C} 1=1, \mathrm{H} 1 \) is equal to \( \mathrm{A} 1 / 2 \) times \( 20 \% \) If it is greater than or equal to 50 and less than 100 , then multiply by 3 If \( \mathrm{D} 1=1, \mathrm{H} 1 \) is equal to \( \mathrm{A} 1 / 2-5 \) And if it is great or equal to than 100 , then multiply by 4 4. Question: 2. Question: If \( \mathrm{D1}<=0 \), then \( \mathrm{D1}{ }^{*} \mathrm{G1} \), If \( \mathrm{D1}>0 \) but \( <=600 \), then \( \mathrm{D} 1^{*} \mathrm{~F} 1 \), \( \mathrm{If} \mathrm{DI}>600 \), then IF \( A 1+B 1<=4 \), the value is 20 \( \left(\left(600^{\circ} \mathrm{F} 1\right)+\left((\mathrm{DI}-600)^{*} \mathrm{E} 1\right)\right. \), otherwise the value is \( \mathrm{Q} \). IF \( A 1+B 1>4 \) but \( <=9 \), the value is 35 5. Question: IF \( A 1+B 1>9 \) but \( \ll=14 \), the value is 50 If B1's value is 1 to 5 , then mutiply E1 by 0,77 IF \( A 1+B 1>15 \), the value is 75 If B1's value is 6 to 10 , then mutiply E1 by 0,735 If B1's value is 11 to 19 , then multiply E1 by 0,7 If B1's value is 20 to 29 , then multiply E1 by 0,675 If B1's value is 30 to 39 , then multiply E1 by 0,65, otherwise by 1 .