Aman wants to calculate an 8% discount on the item price and then the net amount as given in the worksheet
i. What should be the formulas in cells C2 and D2?
ii. How will you copy the formula in cell C2 to C3:C5 and in cell D2 to D3:D5?
Share
Aman wants to calculate an 8% discount on the item price and then the net amount as given in the worksheet
i. What should be the formulas in cells C2 and D2?
ii. How will you copy the formula in cell C2 to C3:C5 and in cell D2 to D3:D5?
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Answer:
i. C2 = B2 * 0.08
D2 = B2 - C2
ii. First calculate the C2 and hold the selection and drag to cell C5 and release. The results will be copied to cell C5. Do the same procedure for D2 also
Explanation: