|
|
|
|
1 |
822 |
|
|
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 |
821 |
|
|
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 |
818 |
|
|
|
|
2 |
818 |
|
|
=if formulae by
Janie
I have and excel spreadsheet which I wish to record an error message if one
cell as a value of more than zero and the cell below it has a value of zero.
I...
|
|
2 |
817 |
|
|
|
|
1 |
815 |
|
|
|
|
1 |
815 |
|
|
|
|
1 |
814 |
|
|
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 |
810 |
|
|
Excel - How to abs entire column by
John E.
I'm new to Excel and would like to change all negative numbers appearing
in a non calculated column to positive numbers. The problem results
from a bug...
|
May 5th, 2004 10:08 AM
by Gordon
|
6 |
810 |
|
|
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 |
809 |
|
|
|
|
1 |
807 |
|
|
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 |
807 |
|
|
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 08:49 PM
by wmaughan
|
1 |
806 |
|
|
|
April 17th, 2010 12:58 AM
by JLatham
|
1 |
805 |
|
|
Salary Reciept by
hikmat
I need to make a Salary Reciept for my office use, i have staff here and i
have to pay them. i need a strong Salary Reciept, so i can pay staff salary
and...
|
|
3 |
805 |
|
|
|
|
1 |
804 |
|
|
New To Formulas - Help please by
kirstikate
This is probably very easy, but im having trouble - I want to find a formula
that does the following
IF H49 + G49 = F49 and F49=I49 then True If it...
|
May 25th, 2010 09:05 PM
by Brad
|
6 |
804 |
|
|
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 |
803 |
|
|
Drop Down List by
Pete
is it possible to choose an item from a dropdown list which will enter
a different value other than that chosen. Why I want to do this is as
follows:
We have...
( 1 2 3)
|
|
20 |
803 |