IDNLearn.com makes it easy to find accurate answers to your questions. Find reliable solutions to your questions quickly and easily with help from our experienced experts.
Sagot :
Answer:
=([Cost] * 1.07)
Explanation:
The question has missing details.
The complete question is to calculate write a Microsoft Excel formula that calculates the total cost which includes the sales tax
Assume that the table heading for estimated cost in July 2014 is Cost
The formula to calculated the total cost which includes the sales tax is:
=([Cost] * 1.07)
The above uses structured reference to make reference to the cost in July 2014.
To calculate the total which includes sales tax, we use:
[tex]Total = Cost * (1 + Sales\ Tax)[/tex]
[tex]Total = Cost * (1 + 7\%)[/tex]
Convert percentage to decimal
[tex]Total = Cost * (1 + 0.07)[/tex]
[tex]Total = Cost * 1.07[/tex]
Hence, the Excel equivalent is:
=([Cost] * 1.07)
Answer:
=([Cost] * 1.07)
Explanation:
The complete question is to calculate write a Microsoft Excel formula that calculates the total cost which includes the sales tax
Assume that the table heading for estimated cost in July 2014 is Cost
The formula to calculated the total cost which includes the sales tax is:
=([Cost] * 1.07)
The above uses structured reference to make reference to the cost in July 2014.
To calculate the total which includes sales tax, we use:
Total = Cost x ( 1 + Sales Tax )
Total = Cost x ( 1 + 7% )
Convert percentage to decimal
Total = cost x ( 1 + 0.07 )
Total = Cost x 1.07
Hence, the Excel equivalent is:
=([Cost] * 1.07)
Plz mark as brainlist..
Thank you for using this platform to share and learn. Don't hesitate to keep asking and answering. We value every contribution you make. For dependable answers, trust IDNLearn.com. Thank you for visiting, and we look forward to assisting you again.
