Sep 11 2018 12:31 PM
I know this should be easy but we had no help at all with this.
Here are the instructions for this step:
"Insert an IF function in cell E5 to calculate the total due. If the student has chosen to personalize the ring, there is an additional charge of 5% located in cell B21 that must be applied; if not, the student only pays the base price. Use appropriate relative and absolute cell references."
Thanks
Sep 11 2018 12:50 PM
Hi thanks for the help.
I did what you said and it came up with a #Value! error.
Sep 11 2018 12:51 PM
I added C5 instead of C4!!! It worked! Thank you!
Sep 11 2018 12:55 PM
Hi Erin,
One more question. =IF((D5="Yes"),(C4*1.05),C4)
Why did you add the 1.05? I can understand it all, but what is the 1 for? .05 is the percentage. Why the 1?
Sep 11 2018 01:53 PM
That's simple maths.
How do you add 5% to a number? Either use number + (number * 0.05) or, shorter, use number*1.05