Question about Microsoft Excel for PC

Ad

There are 2 types of direct cell references that you can use when you're writing formulas: Relative References & Absolute References.

A Relative Reference is the address of a cell (e.g. A5). When a Relative Reference in a formula is copied from one cell to another, the Reference gets changed automatically. e.g. If you put a formula in cell c5 as A5+1, when you copy this from c5 to c6 the formula A5+1 will automatically change to A6+1.

An Absolute Cell Reference does not change when its copied to another location. As in the example above if the formula in cell C5 is written as $A$5+1, if you copy this formula from C5 to C6 it will remain as $A$5+1 (NOT change to $A$6+1.

The $ sign signifies Absolute, and can be applied to the Row reference, the Column reference, or both Column & Row (as in the example).

Posted on Oct 19, 2014

Ad

Hi there,

Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

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: i want the excel compound interest formula

P=13,00,000

R=10%

N=5MONTHS

COMPOUNTED QUERTLY

Posted on Apr 09, 2009

SOURCE: HLOOKUP and IF formula netting problem

The value of C7cannot be found in the range - Hence the error.

Posted on May 22, 2009

SOURCE: Excel will not displaying the results of a trend array formula

Let's say you have a criterion in column A that must be true; any true record should be included in the trend estimate for your unknown X value "5", with X's in column B and Y's in column A, as follows:

A B C

TRUE 1 2

TRUE 2 4

FALSE 3 0

TRUE 4 8

The formula is

=TREND(IF(A1:A4,C1:C4,AVERAGE(C1:C4)),IF(A1:A4,B1:B4,AVERAGE(B1:B4)),5)

This is the only way to do it, because TREND doesn't like falses in the array, and you can't use any other number except for the average, else it will mess with the trend results. Try it for yourself - it works!

Posted on Aug 05, 2009

SOURCE: Excel formula problem, Auto increment number with extra character

hi,

type in A I001 anb in B I002 and select these two if you are placing your cursor at bottom of B you will find one + symbol instead of cursor. just drag that upto I so you will get 009 .In j type I0010 and in k type 0011 and repeat the same procedure mentioned above upto AX.....You will get answer ...If this will help you, voe for me Thank you...

Posted on Oct 29, 2009

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

- All formulas begin with an equals sign
**(=)**. - Some formulas use operands such as
**+,-, *,/**for addition, subtraction, multiplication or division.

For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3. - Other formulas refer to different functions such as SUM, AVERAGE and others.

For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3. - Formulas can be
**combined with operands.**

For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10. - Functions can
**be nested within each other.**

For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

Yes,

That is Select the Cells which you want to SUM and Press**Alt+=**

This will bring the total just below the selected cells.

Thanks

Iqbal

- Select the column. (click on top of the column it will select)
- Right Click and select Format Cells.
- Select
**Currency**in**Category**then press**OK**

That is Select the Cells which you want to SUM and Press

This will bring the total just below the selected cells.

Thanks

Iqbal

Apr 02, 2008 | Computers & Internet

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

The cells you are trying to sum are probably text and not numeric values. Format them as number or convert them to numbers.

Apr 18, 2009 | Microsoft Office Excel 2003 for PC

this is done through formulas. You write them in relationship to one another. Say you put a value into B1 then you write a formula for c2 like =SUM(A1/2)which means the sum of A1 divided by 2. or you can say make a formula that is like this =SUM(A1/C1) which means the value of A1 divided by the value of C1.

Jan 10, 2009 | Computers & Internet

Go to the cell you want this total in.

Type this formula:

=SUM(IF(Sheet2!C1:C10="EME",IF(Sheet2!N1:N10=1,1,0)))

make sure you end the formula with CTRL - SHIFT - ENTER which makes it an array formula. If you forget, go back to the cell with this formula and press F2 (to edit the cell) and press CTRL - SHIFT - ENTER to convert it to an array formula (Excel will show a little {...} around the formula).

Type this formula:

=SUM(IF(Sheet2!C1:C10="EME",IF(Sheet2!N1:N10=1,1,0)))

make sure you end the formula with CTRL - SHIFT - ENTER which makes it an array formula. If you forget, go back to the cell with this formula and press F2 (to edit the cell) and press CTRL - SHIFT - ENTER to convert it to an array formula (Excel will show a little {...} around the formula).

Dec 21, 2008 | Microsoft Excel for PC

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

**columns: A B C D**

**rows**

**1 ** 20 3

**2 ** 10 4

**3 ** 15 2

**4 ** 1 2 3

Then suppose you type in the following formulas (in the D column):

**columns: A B C D**

**rows**

**1 ** 20 3 =A1+B1

**2 ** 10 4 =A2-B2

**3 ** 15 2 =A3*B2

**4 ** 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

**columns: A B C D**

**rows**

**1 ** 20 3 23

**2 ** 10 4 6

**3** 15 2 30

**4** 1 2 3 6

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

Then suppose you type in the following formulas (in the D column):

Then the following answers will appear in the D column:

Sep 29, 2008 | Microsoft Computers & Internet

CHOSE THE PERTICULAR CELL WHERE THE SUM IS GOING TO BE DISPLAYED AND HYPERLINK IT IT WITH SHEET 2

Apr 12, 2008 | Microsoft Excel for PC

at first select the 1st page data and select data-subtotal from the upper menu list.

then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

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,

Sep 15, 2007 | Microsoft Office Standard for PC

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

248 people viewed this question

Usually answered in minutes!

×