Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC
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
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
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.
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.
×
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.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Aug 11, 2010 | Microsoft Office Excel 2003 for PC
Dec 17, 2009 | Microsoft Office Home and Student 2007...
Jul 29, 2009 | Business & Productivity Software
Jun 22, 2009 | Microsoft Excel for PC
Nov 26, 2008 | Microsoft Excel for PC
Aug 08, 2008 | Microsoft Business & Productivity Software
Jan 01, 2008 | Microsoft Office Standard 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
217 people viewed this question
Usually answered in minutes!
yes, i mean the f(x) is "=260+G$2+F60+$X$99+$A25"
and i want the conditional copy.
please suggest me how it will be possibe.
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?
×