Question about Microsoft Computers & Internet
And how to do balance sheet in ms excel with what formulae
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:
Sales Product A
Sales Product B
Cost of Sales Product A
Cost of Sales Product B
Total Cost of Sales
I hope this helps
Posted on Jan 05, 2009
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
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Nov 18, 2016 | Computers & Internet
Jul 29, 2009 | Computers & Internet
Jun 22, 2009 | Microsoft Excel for PC
Sep 13, 2008 | Microsoft Computers & Internet
Apr 04, 2008 | Microsoft Excel for PC
Dec 13, 2007 | Computers & Internet
Nov 24, 2007 | Computers & Internet
603 people viewed this question
Usually answered in minutes!