The following worksheet shows Account no. , Name, Deposit amount, yearly rate of interest and no. of days of deposit. Write steps to compute simple interest in column E assuming 365 day year. (Excel Problems)
The following worksheet shows Account no. , Name, Deposit amount, yearly rate of interest and no. of days of deposit. Write steps to compute simple interest in column E assuming 365 day year.
To compute simple interest in column F,
Enter the formula
=C2*D2*E2/365 in cell F2 and then press enter key,
using the fill handle of cell F2, copy the formula to cells F3 :F15
by dragging the fill handle up to cell F15 .
0 comments:
Post a Comment