Calculate discount as a percentage from sale price and discount amount.
=C2/B2
Calculate a percentage discount.
=B2-C2*B2
Calculate simple interest.
=A2*B2*C2
(calculate simple interest)
=A2+D2
(amount)
where A2
is the Principal
B2
is the interest rate as a percentage
C2
is the time in years