Question about Microsoft Business & Productivity Software

2 Answers

How to do profit and loss a/c in ms excel

And how to do balance sheet in ms excel with what formulae

Posted by on

2 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 728 Answers

Hi saleem_share,
I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:
Description
Amount
Formula
Sales Product A
1,000.00

Sales Product B
1,000.00

Total Sales
2,000.00
SUM(C1:C2)
Cost of Sales Product A
500.00

Cost of Sales Product B
200.00

Total Cost of Sales
700.00
SUM(C5:C6)
Gross Profit
1,300.00
SUM(C4-C7)



Auto
25.00

Utilities
50.00

Payroll
300.00

Office Supplies
20.00

Total Expenses
395.00

Net Profit
905.00
SUM(C8-C14)


I hope this helps

Mark

Posted on Jan 05, 2009

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

First define the name of your complete debit cell and credit cell.means 1st select all expences define with any name,and same with credit. than,go to the net profit cell and type formula =if(cell adress,"","","netprofit") same formula for net loss. than go to the net profit amount cell and type =if(sum(cell address)>sum(cell address),sum(cell address)-sum(cell address) than enter your formula run smoothly and apply same as net loss..... at last coputing total =sum(cell address) than enter..............

hope my effort help.......

Posted on Mar 07, 2011

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Formula for cell that is not blank


You can use IF and ISBLANK. Put this formula on Sheet 1 D1:

=IF(ISBLANK(Sheet3!AM2),"x","")

You can replace "x" by any other value you need.

Mar 04, 2010 | Microsoft Excel for PC

1 Answer

Want to copy formula into multiple excel sheets


why not? however, you can also insert an apostrophe (') at the start of the equation before copying the entire formula so that the formula will be treated as a text thus preserving all cell references. dont forget to remove the apostrophes after you have pasted them though for the formulas to work again.

Jul 29, 2009 | Business & Productivity Software

1 Answer

MS Excel-Values in the formula in place of cell reference


Copy the cell(s) and then right click on the cell(s). Choose Paste Special and then choose Value. That will convert it.

Jun 22, 2009 | Microsoft Excel for PC

1 Answer

EXCEL FORMULA


on sheet2!a1 type =sheet1!a1 - anything you type on sheet1!a1 will appear on sheet2!a1

Sep 17, 2008 | Business & Productivity Software

2 Answers

Excel formulas


type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.
Good luck.

Sep 13, 2008 | Microsoft Business & Productivity Software

4 Answers

How many formulas we can use at a time in Excel


That depends on which version of Excel you are using.
Excel 2003 supports up to 65,335 formulas
Excel 2007 has no limit.
you can communicate between the worksheets which are contained by one workbook (one excel-file).
Communicating between files cannot be done with formula's.

Apr 04, 2008 | Microsoft Excel for PC

2 Answers

Formmulas are not appling in the excel of office xp


Dear chidambar, thats usually because you've mistakenly tampered with a file or because you're putting an inapplicable value. Can you tell me what error is it exactly ?

you might like to re-install your MS excel after backing up your files. You might also like to repaire your ms office from your cd.


if that has helped you plz press fixya.

Dec 13, 2007 | Business & Productivity Software

2 Answers

Excel 2003


Dear Thccsl, if you meant formulas by writing codings then you can find a complete list of formulas by clicking fx button beside the formula bar in MS excel. You can get complete range of forumlas and example and explanation of how to use this formula.

You also might like to see this for detailed information:

http://en.wikipedia.org/wiki/MS_excel

If this solution was helpful please press solved.

Nov 24, 2007 | Business & Productivity Software

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

600 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...