Question about Microsoft Business & Productivity Software

'quintal' appears to be an obsolete term. Can you confirm that you use it as 1 Quintal = 100 kg please? And the abbreviation is . . .?

Jan 24, 2014 | Microsoft Office Excel 2007

Please contact the vendor from whom you purchased the program. FixYa cannot refund a purchase made from another company.

Feb 20, 2013 | Avanquest My Invoices And Estimates Deluxe...

Pounds to Kilogram - multiply by 0.4535924.

Example: 2.5pounds to kilograms = 2.5 x 0.4535924

= 1.133981

Kilogram to Pounds - divide by 2.2046224

Example: 4.32kilograms to pounds = 4.32/2.2046224

= 9.325553

Example: 2.5pounds to kilograms = 2.5 x 0.4535924

= 1.133981

Kilogram to Pounds - divide by 2.2046224

Example: 4.32kilograms to pounds = 4.32/2.2046224

= 9.325553

Jul 29, 2011 | Microsoft Office Professional 2007 Full...

For example, you have three numbers from A1 to A3. On row A4, type =SUM(A1:A3).

That should do it. :)

That should do it. :)

Sep 16, 2009 | Microsoft Office Excel 2007

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

- =A1-A2
- =SUM(A1,-A2)

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

Jul 08, 2009 | Microsoft Office Excel 2003 for PC

if the gram is in cell A1 then

=A1/1000

will give you how many kilograms A1 is

=A1/1000

will give you how many kilograms A1 is

Jun 05, 2009 | Microsoft Excel for PC

Please send the file to my email address c_robertson@yahoo.com and I will review the question.

Apr 28, 2009 | Microsoft Excel for PC

Use the function =sum() to add numbers. To sum, for example, all of column A, enter in the formula bar =sum($A:$A). You can use the subtotal function within the range you are adding and the answer will not count towards the final total.

Mar 14, 2009 | Microsoft Excel for PC

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

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

Jan 05, 2009 | Microsoft Business & Productivity Software

First check the formatting of the cells, then check under file-preferences to see what works is programmed to do, if this gives no clue, you could easily create a copy to experiment on and on the copy, highlight the entire sheet, and clear all functions and formats, then experiment with your calculation, if it performs ok, you will know that there was something else going on in the original cells. Finally, instead of the auto-sum function you could manually put in the sum formula eg D2=sum ( A34:A57)

If all this fails, post back and we'll dig further......good luck

If all this fails, post back and we'll dig further......good luck

Jan 03, 2008 | Microsoft Works 8.0 for PC

87 people viewed this question

Usually answered in minutes!

×