Question about Computers & Internet

Ad

When the cell is in a different sheet in the same file use:

=sheet-name!cell-name as in =Sheet1!A1

If the cell you want is in a different sheet in a different file use:

=[file-name]sheet-name!cell-name

as in: ='[sample excel 2.xls]Sheet1'!$A$1

The easiest way to do it is in the blank cell, type an equals sign "=" then go to the cell you want to copy, then press enter. All the correct formatting will be handled for you. (Sometimes you need quotes when you have spaces in the filenames and or sheet names.)

Posted on Sep 07, 2009

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.

Goodluck!

Posted on Jan 02, 2017

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).

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).

Oct 17, 2014 | Microsoft Excel for PC

The easiest way to do this is to use Excel spreadsheet.

This is what you need to do.

Create a label at the top of each column as detailed.

Add a employee to each row under Name of employee

Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee

2nd column - salary rate per hour

3rd column - hours worked

4th column - gross pay (formula = salary rate X hours worked)

5th column - tax deduction

6th column - other deductions

7th column - total deductions (formula = tax deduction + other deduction)

8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.

You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

This is what you need to do.

Create a label at the top of each column as detailed.

Add a employee to each row under Name of employee

Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee

2nd column - salary rate per hour

3rd column - hours worked

4th column - gross pay (formula = salary rate X hours worked)

5th column - tax deduction

6th column - other deductions

7th column - total deductions (formula = tax deduction + other deduction)

8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.

You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

Mar 24, 2011 | Computers & Internet

I am not sure, but from the expression you wrote I see blank spaces. You should not leave any spaces between X and the division sign, nor between the / and the parenthesis (. Furthermore the 1 in front of X^2 is unnecessary).

You should type it this way X/X^2. Written this way you notice that you can simplify by X and just write 1/X or X^-1 (the key below the MATH key and above X^2).

To summarize: Do not insert blank spaces in formulas.

You should type it this way X/X^2. Written this way you notice that you can simplify by X and just write 1/X or X^-1 (the key below the MATH key and above X^2).

To summarize: Do not insert blank spaces in formulas.

Sep 18, 2010 | Texas Instruments TI-84 Plus Silver...

Try using "count if blank"

I am assuming that you need the value to be on sheet 3

If you want the value to be on another sheet, it is more complicated, you will have to "paste special" the value to a different sheet.

I am assuming that you need the value to be on sheet 3

If you want the value to be on another sheet, it is more complicated, you will have to "paste special" the value to a different sheet.

Jul 22, 2010 | Microsoft Office Excel 2007

You can use IF and ISBLANK. Put this formula on Sheet 1 D1:

=IF(ISBLANK(Sheet3!AM2),"x","")

You can replace "x" by any other value you need.

=IF(ISBLANK(Sheet3!AM2),"x","")

You can replace "x" by any other value you need.

Mar 04, 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

Below is the formula for "2". The logic should be obvious from this so you can adapt for "1" or a combination of 1 and 2. This need to be written as one long formula so I have pasted it in to this reply so you can do a copy and paste into your spreadsheet. Sorry its not very readable in this form but you could paste into word so you can break it down and examine structure.

=IF(OR((AND(Sheet3!A12="WA",OR(Sheet3!AH2="Lewis",Sheet3!AH2="Pacific",Sheet3!AH2="Wahkiakum"))),(AND(Sheet3!A12="OR",OR(Sheet3!AH2="Clackmas",Sheet3!AH2="Multnomah",Sheet3!AH2="Washington")))),"X"," ")

=IF(OR((AND(Sheet3!A12="WA",OR(Sheet3!AH2="Lewis",Sheet3!AH2="Pacific",Sheet3!AH2="Wahkiakum"))),(AND(Sheet3!A12="OR",OR(Sheet3!AH2="Clackmas",Sheet3!AH2="Multnomah",Sheet3!AH2="Washington")))),"X"," ")

Aug 18, 2009 | Microsoft Office Excel 2007 Full Version...

You can link to the original sheet or copy and paste - Linking might be easier as you only have 10. - Can you not use worksheets rather than excel. If you want to make it more autonomous you can index or look up the first sheet so any changes you make will be reflected back in your employee sheets.

May 26, 2009 | Microsoft Office Excel 2003 for PC

You can do that using the formula CONCATENATE, solving your report.

in C2 you could write: =CONCATENATE(A2,B2)

in C3 you could write: =CONCATENATE(A3,B3)

in C4 you could write: =CONCATENATE(A4,B4)

in C5 you could write: =CONCATENATE(A5,B5)

in C2 you could write: =CONCATENATE(A2,B2)

in C3 you could write: =CONCATENATE(A3,B3)

in C4 you could write: =CONCATENATE(A4,B4)

in C5 you could write: =CONCATENATE(A5,B5)

Nov 24, 2008 | Microsoft Office 2003 Basic Edition...

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

Dec 16, 2017 | Computers & Internet

Dec 16, 2017 | Computers & Internet

111 people viewed this question

Usually answered in minutes!

×