Question about Excel Computers & Internet

Ad

Hi,

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.

Good luck!

Posted on Jan 02, 2017

Ad

SOURCE: excel formula

Relative cell reference is address of cell , when copied from one cell to another gets changed automatically.

e.g. Put formula in cell c5 as A5+1 when you copy this from c5 to c6 the address of A5 will automatically changed to A6.

Absolute Cell Reference

As above now put formula in cell C5 as $A$5+1 ,now copy this formula from C5 to C6 if you this formula youwill find cell Address of A5 does not changed.

Mixed Cell Reference:

If we put Dollar ($) sign before Alphabetic cell address i.e.$c5 then even if you copy this formula in any cell , coloumn (c) will remains constant.

Similarly if we put Dollar ($) sign before Numeric cell address i.e.c$5 then you copy this formula in any cell row address of the cell remains same.(5).

Pl elobarate on remaining two points 'Specific order of formulas ' and 'advance formulas,

Posted on Oct 16, 2007

SOURCE: EXCEL SPREADSHEET FOR INVENTORY

Dear pauline, you can link cells in formula bar to see immediate effect of additions and subtractions in dependent boxes.

Like for example you add three numbers in three boxes A1, B1, C1 and answer is supposed to go in D1, just type =SUM(A1+B1+C1)

in D1.

now when you will change the values of a b and c boxes, the value of d1 will automatically change. for adding more numbers you can leave boxes empty so that you can fill in later to see the change in the sum box.

please press fixya if that has helped you.

Posted on Dec 12, 2007

SOURCE: FORMULA FOR FINDING PERCENTAGE

find "fx" on your toolbar; choose all formulas find percentage, you can set a specific percentage to the cell, just put the number you want a percentage of or if you want to keep that number, put the percentage formula in the next cell <%a:2>

Posted on Apr 26, 2009

SOURCE: how do you subtract

Its a little strange. Suppose you want subtract 10 from 38. Do this:

Enter 38 press plus key.

Enter 10, press minus key.

Press the equal sign. You will have the result.

Posted on Oct 22, 2009

SOURCE: how many formulas we can use at a time in Excel

You have no limit It depends on your logical thinking and he kind of problem that you want to resolve

Posted on Oct 28, 2016

EXCEL view the operation as a function fX and you enter it like this: =MINUS(H21,H22) This will show up in the cell and on the function bar above the column letters. The cell number would have a value in it. In this example H21 would have the value 10,and H22 would have the value 5. The formula would reside say in H23 and would show the result of the operation as 5.

10

5

5 (Formula in cell is as shown above)

10

5

5 (Formula in cell is as shown above)

Sep 19, 2017 | Excel Computers & Internet

put in result row

=A1-A2

or = A1-A2-A3

A being the column

the numbers 1 2 3 are the rows

or go to result cell type =

then click on cell then press -

then click on cell to minus then press -

the click on next cell to minus

=A1-A2

or = A1-A2-A3

A being the column

the numbers 1 2 3 are the rows

or go to result cell type =

then click on cell then press -

then click on cell to minus then press -

the click on next cell to minus

Dec 08, 2016 | Computers & Internet

1. Make sure you have entered the numbers you'll need in necessary columns

2. Go to the column you would want the results to appear in

Guide: + (addition); -(subtraction); *(multiplication); /(division)

3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on

4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

2. Go to the column you would want the results to appear in

Guide: + (addition); -(subtraction); *(multiplication); /(division)

3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on

4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

Aug 03, 2010 | Microsoft Excel for PC

Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Nov 05, 2009 | Microsoft Office Excel 2003 for PC

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

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 Computers & Internet

Step1. Start Microsoft Excel and open the file you want to change.
Step2. Double-click on the cell where you want the total to appear.
Step3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell.
Step4. Enter the formula, then press Enter. Follow the steps below for an example.
Step5. Enter an opening parenthesis character: (.
Step6. Enter a cell name. For example: =(E2.
Step7. Press the + key.
Step8. Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3).
Step9. Enter a minus sign and a third cell name. For example: =(E2+E3)-E4.
Step10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell.
$('.Article .Steps .Image').each(function(i,e){
e = $(e);
e.find('img').error(function(){
$(this).unbind();
e.remove();
});
});

Tips & Warnings

Tips & Warnings

- Formulas are just equations. Instead of adding or subtracting numbers you are adding and subtracting the contents of a cell.
- Excel includes a number of predefined functions to use as well. You can combine the predefined functions into your own formula. (See "How to Use Provided Excel Formulas.")

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Add 1 + 1: =1+1

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1

Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2

Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Aug 08, 2008 | Microsoft Computers & Internet

meri excel file ka security paasward missing. Pls i want track the paasward.

Jul 13, 2008 | Microsoft Excel for PC

84 people viewed this question

Usually answered in minutes!

×