|
|
Calculate number of days by
Linda P.
I am using Excel 2000.
I need help with a formula. In A1 I have # of years, in A2 I have # of
months and in A3 I have # of days. In A4 I want to add A1...
|
|
7 |
326 |
|
|
|
|
1 |
190 |
|
|
Ctrl V paste coding was lost by
peanut40
I wrote a macro and coded it to ctrl v which overwrote the paste function on
the Ctrl V shortcut key, how do I replace the paste function coding? Or where...
|
|
1 |
212 |
|
|
Modify general format to date format. by
SherryS
When importing from payroll, it gives me all dates formatted as general
numbers (i.e. 07/17/2009 is presented as 7172009. Is there any way to
convert these...
|
|
2 |
206 |
|
|
|
|
2 |
226 |
|
|
error alert for invalid date by
nader
hi
I want excel showes error alert if user enters invalid dates like
"2010/2/29"...
I can not creat it on data validation.
|
April 27th, 2010 11:51 AM
by nader
|
2 |
222 |
|
|
Cell Formatting of a Conditional Statement by
RobFJ[_4_]
I want to be able to change the background of a cell colour if a second
condition is met - but for the background to remain unchanged if the first
condition...
|
|
3 |
197 |
|
|
Index using a defined name array by
Swimmer1500m
I have defined 3 arrays using DefineNames:
Boys_11_12
Boys_13_14
Boys_15_16
I then have defined a Combo dropdown with the following...
|
|
1 |
214 |
|
|
|
|
3 |
253 |
|
|
Nested IF & AND functions by
Stana1027
Trying to calculate bonus's for employees working 1 year, and based on their
pay grade. Yet I'm getting #value, and Excel says I'm using the data type?
help...
|
|
4 |
224 |
|
|
Excel Formula for years and months by
Newfie809
If the formula for number of years is =Year(latest date)-Year(earlier
date)
this formula only show the nubmer of years, and I would like it to show the...
|
|
2 |
201 |
|
|
|
|
2 |
241 |
|
|
Can you AVERAGE IF and not null? by
Spottkitty
=AVERAGE(IF($A$3:$A$45="Photo",H3:H45))
This is the array I'm using to try to determine an average. Problem...if
the field is blank it's counting it as zero...
( 1 2 3 ... Last Page)
|
|
51 |
2,138 |
|
|
Vlookup by
jacki
What is the best way to be able to enter a number into a cell and it returns
the name that corresponds with that number in the cell to the right of it.
The...
|
April 26th, 2010 11:12 PM
by UKMAN
|
6 |
250 |
|
|
INDIRECT reference or ? by
Tom
Excel 2007 all MS updates
I need to search ANY column of numbers, say Column AL, to determine if any
of the values are below or above a value that I'm wanting...
|
|
8 |
321 |
|
|
|
|
0 |
234 |
|
|
Formula addition causes random #REF! by
stevew
I have added a new formula to ledger worksheets and now the #REF! appears in
areas in the workbook. In order to fix it, all I have to do is copy a good
cell...
|
|
1 |
207 |
|
|
Formula Help by
jlo
In my "Total Days" column, I have the following formula and it works:
E4 is Date sent to Vendor
=DATEDIF(A3,TODAY(),"d")
now, I want to add to this...
|
|
5 |
199 |
|
|
Satisfying two conditions? by
Zuo
I need to satisfy the following condition: If the longest side of a box is
greater than 60 or its second longest side is greater than 30, then charge
$8. I...
|
|
8 |
204 |
|
|
what should be simple by
Rene
b2 =min(g2,o2,w2,ae2)
g2 =k2/n2
o2 =s2/v9
....
b2 works when all the cell formulas have data to compute, but does not work
when one of the formulas returns...
|
|
4 |
208 |