answersLogoWhite

0


Best Answer
  1. Make a column or range of columns to contain your income entries.
  2. Add a SUM at the bottom of the income column.
  3. Make a column or range of columns to contain your expense entries.
  4. Add a SUM at the bottom of the expenses column.
  5. Add a cell that subtracts your expenses from your income to indicate your profit.

See related links for an example of a detailed Profit Loss Report.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

12y ago

create a formula in cell C13 that determines whether you will make a profit or loss

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the procedure to calculate profit and loss data in Microsoft Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is Excel and Entourage?

Excel is a Microsoft software designed to calculate formulas and is in a spreadsheet layout. Entourage is the Mac version of Microsoft Outlook.


On Microsoft Excel what do you need to write to calculate things?

Formulas.


Can a person complete calculations in Microsoft Excel 2003?

Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.


How do you calculate a discount in Microsoft Excel?

See the explanation in the related link.


How do you calculate Microsoft Excel sheet Debt-Service Coverage Ratio - DSCR?

Calculating DSCR in Excel sheet


How does Microsoft Excel helps in accounting?

It can calculate numbers and set out tables and graphs


How do you calculate a concession stand profit?

To calculate profit, you would need to measure the revenues and expenses generated by the business over a given period. You would then subtract the expenses from the revenues to calculate the amount of profit. It might be helpful to invest in accounting software designed for small businesses such as Peachtree or Quickbooks. It is also possible to record revenues and expenses by hand or by using a simple spreadsheet program such as Microsoft's Excel.


Who are the creators of Microsoft Excel?

Microsoft excel was created by Microsoft


How do you launch Microsoft Excel?

Programs->Microsoft Office->Microsoft Excel


You have Microsoft Excel 2007 version you need to have your total cost column to calculate the cost from two columns How do you do this procedure?

Use the SUM function and separate each range with a comma.EXAMPLE:=SUM(A1:A23,B1:B23)


What is the spreadsheet program in Microsoft office 2007?

I believe the only Microsoft program used to create spreadsheets is Microsoft Excel.


Is there any hidden game in Excel 2003?

There are no hidden games in Microsoft Excel after Microsoft Excel 2000, so there are none in Microsoft Excel 2003.