Question

Write single MS Excel formula or function for the following: (Use cell referencing) a) Decrease the value of cell C30 by 15%. (1.5 marks) b) Calculate the simple interest if T, P and R% are given in cells D4, D5 and D6 respectively. (2.5 marks) Calculate the compound Interest using the values in cells D4, D5 & D6 in part b)​

Answer 1

Microsoft Office Excel formulas are used to perform computations either directly or when used as a function

Formula to decrease C30 by 15%

If cell C30 is decreased by 15%, then only 85% of its value would remain

i.e. 85% of C30

So, the formula for this is:

= 0.85 * C30

Formula to compute simple interest

The formula for simple interest is:

I = PRT

Where R is in percentage.

In this case:

T ⇒ D4

P ⇒ D5

R ⇒ D6

So, the formula for this is:

= D5 * D4 * D6

Formula to compute compound interest

The formula for compound interest is:

I = P(1 + R)^T - P

Where R is in percentage.

In this case:

T ⇒ D4

P ⇒ D5

R ⇒ D6

So, the formula for this is:

= D5 * (1 + D6)^D4 - D5

Read more about Excel formulas at:

https://brainly.com/question/14299634

#SPJ1