Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC

Formula for copy multiple cells at a time

Write a formula when the content of cell L44 if copied to the following cell in excel-

O 24, L 80, M 44, Q 90, I 49

where L 44 =>260+G\$2+F60+\$X\$99+\$A25

Posted by on

• 1 more comment
• chanchal_222 Dec 30, 2008

yes, i mean the f(x) is "=260+G\$2+F60+\$X\$99+\$A25"

and i want the conditional copy.

• chanchal_222 Dec 30, 2008

please suggest me how it will be possibe.

• Peter Sturniolo May 11, 2010

Need a little clarification; 1st do you mean that in L44 the f(x) is "=260+G\$2+F60+\$X\$99+\$A25"?

Do you want a straight copy of cell L44 to the 5 cells indicated, or a conditional copy?

×

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that gotĀ 5 achievements.

Governor:

An expert whose answer gotĀ voted for 20 times.

Hot-Shot:

An expert who has answered 20 questions.

• Expert

You'll want to use the IF formula, its syntax goes like this: =IF(condition to be met,value if true,value if false)

If you want to use text for the true/false values, you'll need to put the term in quotes.

Example, lets say you want to know if 260+G\$2+F60+\$X\$99+\$A25 is equal to 1024, then the formula would be: =IF(260+G\$2+F60+\$X\$99+\$A25=1024,"True","False")

Posted on Dec 30, 2008

• Peter Sturniolo Dec 30, 2008

To clarify a little more, you don't necessarily have to include the entire operation in the IF statement, you can just enter =IF(L44=1024,"True","False") in any of the other cells.

• Peter Sturniolo Dec 30, 2008

And you can copy the cell in question by placing the cell id in the Value if true section.

i.e. for O24: =IF(L44=1024,L44," ")

This would return 1024 in O24 if the value of L44 is 1024 and a blank space if it is not.

×

Hi,
a 6ya Technician 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 repair professionals here in the US.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

Related Questions:

When i copy a sum formula in excel the first cell does not remain the same it increments by 1. how can I prevent this?

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

Oct 17, 2014 | Microsoft Excel for PC

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.

1. All formulas begin with an equals sign (=).
2. 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.
3. 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.
4. 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.
5. 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

Problem was found in Micorsoft excel 2003. When I copy the formula from one (original) cell to another (new) cell, the formula in the new cell has updated but the value show on the new cell was the...

Once you have copy the cell from where the formula cam from, on the destination cell,
go to
1. Edit
2. Paste Special
3. Formula.
4. Press Enter

This should resolve your problem. Regards.

Aug 11, 2010 | Microsoft Office Excel 2003 for PC

Why don't formulas copy from cell to cell?

Step 1
Determine what formula is to be copied and to what location it is to be copied. Carefully consider the cells that are to be referenced in the formula and that they are indeed the cells that contain the information to be acted upon by this formula.
Step 2
Highlight a cell that has the formula in it and click the right mouse button. Select the "Copy" option.
Step 3
Move to the new destination cell for this formula, right click the mouse button and select "Paste."
Step 4
Check the first cell to make sure the correct calculation has been performed. If not, check the formula that appears in the cell that contains the result of the formula that was just copied. Make sure that the formula references the correct cells. If not, correct the formula and then copy the corrected formula to the rest of the cells that should have this formula applied to them.

The only time I have seen this not work is when the cells/pages are protected.

Note:
Some formulas will require references to multiple pages or a workbook. Make sure that the absolute cell address is used for specific numbers and those that are to be applied to subsequent cell addresses are clearly denoted by the use of "\$" in the cell address.

Dec 17, 2009 | Microsoft Office Home and Student 2007...

Want to copy formula into multiple excel sheets

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

MS Excel-Values in the formula in place of cell reference

Copy the cell(s) and then right click on the cell(s). Choose Paste Special and then choose Value. That will convert it.

Jun 22, 2009 | Microsoft Excel for PC

EXCEL FORMULA NOT WORKING

No tmaking promises but try pushing F9 and for future make sure the Automatic caluculation is turned on.

Nov 26, 2008 | Microsoft Excel for PC

Computer

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

Exel 2003

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
1. Click the cell in which you want to enter the formula.
2. 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).
3. Click the tab for the worksheet to be referenced.
4. Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

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,

Sep 15, 2007 | Microsoft Office Standard for PC

Open Questions:

Related Topics:

220 people viewed this question

Level 3 Expert

Level 3 Expert