Question

Write the Excel Formulae for the following statements.
a) Apply a 30% discount to the original price in cell A5 to get a new price.
b) Determine the percentage increase from the value in cell B2 to the value in C2.
c) Find the median of A2: A10 and subtract from the square of 25.
d) Find the fifth root of the value in E6 and divide the result by the average of values in cells D6:D20.
e) The product of the statistical range and the median of the values in these cells, F12:K12, M20 and N15.
f) Cube the average of A11: A30 and multiply the result by half of B10.
g) Write an IF () statement that returns “Discount” if the value in cell B2 is greater than or equal to 80, otherwise calculate an “increase of 15%”on B2.

Answer 1

Here are the corresponding Excel formulas for your statements:

a) **Apply a 30% discount to the original price in cell A5 to get a new price:**
```excel
=A5 * (1 - 0.30)
```

b) **Determine the percentage increase from the value in cell B2 to the value in C2:**
```excel
=((C2 - B2) / B2) * 100
```

c) **Find the median of A2:A10 and subtract from the square of 25:**
```excel
=25^2 - MEDIAN(A2:A10)
```

d) **Find the fifth root of the value in E6 and divide the result by the average of values in cells D6:D20:**
```excel
=E6^(1/5) / AVERAGE(D6:D20)
```

e) **The product of the statistical range and the median of the values in these cells, F12:K12, M20 and N15:**
```excel
= (MAX(F12:K12, M20, N15) - MIN(F12:K12, M20, N15)) * MEDIAN(F12:K12, M20, N15)
```

f) **Cube the average of A11:A30 and multiply the result by half of B10:**
```excel
=(AVERAGE(A11:A30)^3) * (B10 / 2)
```

g) **Write an IF() statement that returns “Discount” if the value in cell B2 is greater than or equal to 80, otherwise calculate an “increase of 15%” on B2:**
```excel
=IF(B2 >= 80, "Discount", B2 * (1 + 0.15))
```

Feel free to adjust any formulas as necessary based on the contextual needs of your Excel workbook!