1.Calculate the revenue of each sale

In cell F3, write the formula:

=(C3*D3)-(C3*D3)*E3

Press Enter and click to drag it until the last cell of the data sheet

2.Calculate the total revenue

In cell F10 write the formula:

=SUM(F3:F9)

Press Enter and click to drag it until the last cell of the data sheet

3.Calculate the net income of each sale

In cell H3, write the formula:

=F5-(F5*2/100)

Press Enter and click to drag it until the last cell of the data sheet

4.Calculate the total net income

In cell H10, write the formula:

=SUM(H3:H9)

Press Enter and click to drag it until the last cell of the data sheet

SUM(number1,number2, ...)

HTML Comment Box is loading comments...

This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:

C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.