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
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.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
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 | Computers & Internet
Jun 22, 2009 | Microsoft Excel for PC
Aug 08, 2008 | Microsoft Computers & Internet
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
220 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: