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: