Question about Microsoft Excel for PC

Jhgfjg

Posted on Oct 25, 2008

Hello

yes it is.

example

sheet1

A1 (50)

A2 (50)

sheet2

(A1)=

"=Sheet1!A2+Sheet1!A1" <-this is the actually code in sheet2 column A1

ok let me explain

in A1 and A2 in sheet1 you got 50 and 50 like numbers.

in A1 on Sheet2 you have = sheet1 a1 + sheet1 a2.

did you get it?

dont know else how I should explain it...

good luck

Posted on Oct 09, 2008

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

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

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

=VLOOKUP(A2;Sheet1.$A$3:D27;2;0)

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets

A2 is the cell I want to look up

Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $

2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns

0 is the value to complete the formula

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets

A2 is the cell I want to look up

Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $

2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns

0 is the value to complete the formula

Feb 11, 2009 | Microsoft Excel for PC

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.

Good luck.

Sep 13, 2008 | Microsoft Business & Productivity Software

i want all excel formula

Jun 15, 2008 | Microsoft Business & Productivity Software

You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (**!**)
to the cell reference. In the following example, the AVERAGE worksheet
function calculates the average value for the range C1:C10 on the
worksheet named Marketing in the same workbook.

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively

- Click the cell in which you want to enter the formula.
- In the formula bar (formula
bar: A bar at the top of the Excel window that you use to enter or edit
values or formulas in cells or charts. Displays the constant value or
formula stored in the active cell.)
, type
**=**(equal sign). - Click the tab for the worksheet to be referenced.
- Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

Heyo. I have had this problem before too. This procedure prevents the cells that contain the formula from being edited.

Wayne

- Select the range of cells whose formulas you want to hide. You can also select the entire sheet.
- On the
**Format**menu, click**Cells**, and then click the**Protection**tab. - Select the
**Hidden**check box. - Click
**OK**. - On the
**Tools**menu, point to**Protection**, and then click**Protect Sheet**. - Make sure the
**Protect worksheet and contents of locked cells**check box is selected.

Wayne

Dec 28, 2007 | Business & Productivity Software

Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.

Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data

Select the entire data and do an auto filter

In column F filter the data by Duplicate and delete all these rows

What remains should be unique data

Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data

Select the entire data and do an auto filter

In column F filter the data by Duplicate and delete all these rows

What remains should be unique data

Dec 19, 2007 | Business & Productivity Software

Dear jois you can make a link from one sheet to other sheet by making a hyperlink. When you will click one cell in first sheet it would shift the sheet in the cell you will fix it.

You can follow this process:

You can follow this process:

- Select a cell that contains the external formula
- Highlight the File path and sheet name in the Formula bar, eg; 'L:\Daves\[Book2.xls]Sheet1'!
- Push Ctrl+C then push Enter.
- Select the range of cells you wish to change the reference in and go to Edit>Replace.
- Select in the Find what box and hold down the Backspace to ensure you do not have a space.
- Push Ctrl+V.
- Do the same in the Replace with box and then edit the file path to the new one needed.
- Click Replace All

Nov 29, 2007 | Microsoft Excel for PC

Jan 28, 2016 | Microsoft Excel for PC

178 people viewed this question

Usually answered in minutes!

×