|
|
Function IF statement by
Raymond
I need to know how to get this column to say: If the hours worked are more
than 40 then take time and a half and multiply that times the difference
between...
( 1 2)
|
|
11 |
136 |
|
|
"add parenthesis" by
PatrickP
I type in the following formula and keep getting the error message that it is
missing a parenthesis. No error message when using the "pop up" window to...
|
|
6 |
102 |
|
|
find combination of cells that equal a sum by
Billy Rogers
A friend of mine asked me this question and I have no idea how to do this
Would there by chance be a function in Excel where you can choose a range of
cells...
|
|
1 |
245 |
|
|
One change makes many changes by
Ptrcip
Is there a way to make a change in a workbook and have it automatically make
the same change in worksheets in the same workbook?
|
|
1 |
89 |
|
|
data format by
joec
Is there any way to convert data that excel is not recognizing so that it is
in a uable form? For example if I copy data from a web report into excel. The...
|
|
3 |
81 |
|
|
Can this be done«? by
Pascale
Hello,
I will do my best in explaining what I would like to do. Thank you in
advance for taking time into figuring this out. I have a file that keeps log
of...
|
February 2nd, 2008 01:04 AM
by Pascale
|
3 |
82 |
|
|
Nesting sumif functions by
JT
I am trying to nest a sumif function but having trouble.
I have a spreadsheet that lists multiple cost/revenue types with multiple
business units. I am...
( 1 2)
|
February 2nd, 2008 12:04 AM
by Max
|
10 |
119 |
|
|
|
|
9 |
66 |
|
|
|
|
2 |
64 |
|
|
Index Problem by
Tracey
I am working on a spreadsheet (excel 2002) showing work schedules (A or P).
On the first sheet I...
|
|
5 |
85 |
|
|
|
February 1st, 2008 09:46 PM
by Jim
|
3 |
63 |
|
|
Help with this formula by
LiveUser
What am I doing wrong?
I know I have to do control shift enter for an array but I am receiving an
error saying my formula is wrong. Can I even so...
|
|
6 |
46 |
|
|
|
|
4 |
68 |
|
|
COUNTA counting formulas as well. by
Gaurav[_3_]
F17/(AVERAGE(C17,B17))*(12/(COUNTA(B5:B16)))
in B5:B16, I have this formula..
=IF(SUM(Start:End!B5)=0,"",SUM(Start:End!B5))
Now the problem is...the COUNTA...
|
|
2 |
52 |
|
|
if x then autofill a color by
epankow
I want a cell to fill in a color if the result is positive and another
color if teh result is negative.
I can use the if - then function fairly well but I...
|
|
1 |
53 |
|
|
Delete part of a cell by
Francis
I have a spreadsheet with 10,000 rows with this information;
Rows look like this,
R1 Ontime: 100.00%
R2 711 *OEM1676EN
R3 Tot
R4 Ontime: 92.00%
R5 129...
|
February 1st, 2008 07:58 PM
by Francis
|
5 |
65 |
|
|
Combo Box by
Morfeo
Hello, How's it going?
Look, i created a data validation in a excel sheet with a customer list, i
have the cells with the validation, i have created a "combo...
|
|
7 |
99 |
|
|
E-mailing Master Summary only by
Sharon
I have created a workbook with about 15 sheets. I then have a Master sheet
which summarizes the information. I don’t want to e-mail all the sheets,
just...
|
February 1st, 2008 07:29 PM
by Sharon
|
3 |
73 |
|
|
Lookup I think by
DP7
I am not sure what function to use to get this done. I have a number in Colum
A that may or may not have up to 5 corresponding values in Colum B. I have a...
|
February 1st, 2008 07:06 PM
by CLR
|
1 |
64 |
|
|
|
|
1 |
74 |