Microsoft Excel 2010 help? please!?

I need an example of a formula for the following description. Create a formula to calculate the total with the insurance. Multiply E6 by 1+ the insurance rate to calculate the result, Enter the insurance rate as a mixed cell reference in the formula, making the row number absolute. Insurance rate: 8% 10 points for best answer. Please and thank you!

Written by Aragornaladdin in Software

Better Answer

Enter the insurance rate in E7 then enter this formula in F6 (choose whatever cells you want and make the change to the formual)

=E6*(1+E$7)

This takes the value in E6 and multiplies it by the value in the parentheses. The value in the parentheses is the % which is a decimal value of 0.08 and the +1 makes the total 1.08 . When you multiply E6 by this 1.08 you are actually adding the value of the E7 percentage to the value in E6.

The $ before the 7 makes row seven absolute.

Written by Scrawny

Other Answers

The only other thing you can do is browse google and see if anyone else has gotten an answer to this problem.
Theres maybe been around one or two people a week on here asking for help but as far as i've seen no ones ever gotten an answer.

Prepared by 1 Plus 1
Thank you very much ahead of time.

Written by 1 Plus 1

Enter the insurance rate in E7 then enter this formula in F6 (choose whatever cells you want and make the change to the formual)

=E6*(1+E$7)

This takes the value in E6 and multiplies it by the value in the parentheses. The value in the parentheses is the % which is a decimal value of 0.08 and the +1 makes the total 1.08 . When you multiply E6 by this 1.08 you are actually adding the value of the E7 percentage to the value in E6.

The $ before the 7 makes row seven absolute.

Written by Scrawny