In: Computer Science
insert an If function in cell 5 to calculate the total due, if the student has chosen to personalize the ring there is an additional charge of 5% located in cell B12 that must be applied: if not the student only pays the base price. Use appropriate relative and absolute cell references in excel
Steps to follow:
1. Open excel sheet.
2.Enter all sample field data.(Name,Ring type,Price,Personalize).
3. For Inserting IF condition. Go to tab formulas --> Insert function f(x).
4. Choose IF function from the list.
5. Enter the condition for IF condition as given in the below image.
6. Total field will be updated for 1 row.
7. Scroll down from E5 to E9 to update all the total as given below.
8. Final output is as follows: