|
|
Comparing, Matching, and Sum formula by
ma
Hello.
Column A has dates. The format is 2010-04-29. There are multiple rows with
the same date.
Column B has numbers
Please, provide me the formula IF:...
|
|
6 |
864 |
|
|
|
|
1 |
860 |
|
|
|
|
2 |
860 |
|
|
Converting Quatro Pro files to Excel by
Phil at Richardson
We have a large number of files used in product costing, which have been created in Quatro Pro 7. We would like
to begin using Excel, instead of Quatro Pro. ...
|
|
1 |
859 |
|
|
sum of cells containing text by
charlotte
I have a selection of cells and i need the sum if they contain text anyone no
if this is possible?
|
|
3 |
858 |
|
|
Header by
Belin
I am new to this Excel 2007 and don't know how to put a title where the
lettered columns are. I need it to be centered across 4 columns. Thanks for
the help
|
|
1 |
857 |
|
|
if/or formula by
Barny[_6_]
I would like to return the result in cell K132 based on the following-
Cell K132 will return the result N or M when/if I132 = N or J132 = M
Cells I132 and...
|
|
2 |
856 |
|
|
Help with If statement by
gls858
I have this If statement in H12 and it works except when E12 is blank I
want H12 to be blank.
=IF(E12=0%,"Closed",IF(E12=100%,"closed","open"))
I'm not sure...
|
May 18th, 2010 06:22 PM
by gls858
|
2 |
856 |
|
|
|
|
1 |
854 |
|
|
|
|
1 |
853 |
|
|
files corrupted on save by
Joe
Office xp with sp2, excel 2002 files are corrupted on save
and excel closes. Opening excel, file is recovered
however all the formatting is lost.
|
|
6 |
852 |
|
|
how do I enter this in excel sumif by
kiki
enter formulas to calulate the total for each sale and the amount of
commission earned by each sale using the following information:
House sold for...
|
|
2 |
851 |
|
|
|
|
1 |
850 |
|
|
|
|
1 |
849 |
|
|
|
April 17th, 2010 12:58 AM
by JLatham
|
1 |
845 |
|
|
|
|
1 |
844 |
|
|
Excel always in bold by
Scarlett50
When I do entries on the excel spreadsheet in Gill Sans its looks ok ie Gill
Sans font size 10 normal but when I print it always comes out in bold even...
|
April 9th, 2010 03:46 PM
by SueW
|
1 |
842 |
|
|
Conditional formula with an if statement by
Tyler2006
I am wanting to create a "envilope" budget sheet and have ran into a problem.
What I am trying to do is make everything in Column B all negative unless I
put...
|
|
1 |
842 |
|
|
Radio Buttons in Excel 2007 by
newby
I am fairly new at using radio buttons. Finally found them through the
Developer Ribbon. Having trouble getting them to work as we would like them
to. We...
|
|
3 |
842 |
|
|
How do I update copy of worksheet by
Al
Is there a way to update a copy of a spreadsheet(2 worksheets of 4 on
source) without manually opening the copy and updating the links?
|
December 28th, 2005 07:49 PM
by wmaughan
|
1 |
839 |