|
|
OR Function Problem by
Jamie
Hi all,
I'm hoping someone can help me. I have written the
following formula and it works exactly how I want it to.
=IF(OR(N7=""),"...
|
November 12th, 2003 11:59 AM
by Jamie
|
3 |
108 |
|
|
Average by
Troy
A B C
Jan-01 340 1
Jan-15 210 1
May-04 130 5
May-25 222 5
Aug-17 434 8
Aug-19 110 ...
|
November 12th, 2003 12:49 PM
by Troy
|
6 |
126 |
|
|
TIME FUNCTION CALCULATION by
Arthur Pong
I'm using Excel 2000.
Scenario:
If I put in cell A1 56.7 seconds (represented by
00:56.7), and for the cells in the same Column A (starting
from A2), I want...
|
|
2 |
99 |
|
|
More help on a current issue by
lynn
I posted an issue last week and got a great result. I need
to take this a step further, though. I'm copying the
string of Text outlining my issue and the...
|
November 12th, 2003 01:41 PM
by Paul
|
1 |
372 |
|
|
Conditional color based on formula in cell by
Ron Gommers
Hi,
How can I conditionally color cell's in excel based on whether they contain
a formula or not.
When searching for the answer, i haven't even been able to...
|
|
1 |
333 |
|
|
IF by
Nishcas
I'm trying to set up a formula that will subtract one date
and time from another, but must be less than another
column to provide true or false. **I only want...
|
November 12th, 2003 02:01 PM
by Nishcas
|
0 |
118 |
|
|
COUNTIF by
Roy Goddard
Hi there
I want to use countif to count the numbers in a row that are 'greater than'
but 'less than'
something like =COUNTIF(P3:U3,"5", "25") but can't get...
|
|
3 |
152 |
|
|
Detecting Cell Format Using Named Formula by
KL
Hi there,
About a year ago I found in the Internet a tutorial on how to create a
formula that would detect some of cell formats. It used some long and
complex...
|
|
5 |
396 |
|
|
|
|
1 |
496 |
|
|
Excel Word Count by
Jesse Wiggins
The LEN function counts characters, however, I am not aware of a function to
count words. Looks like you get to VB.
-Jesse
"Jon Capuchino"...
|
|
3 |
270 |
|
|
min conditional statement by
Maria L
I am trying to find a the smallest number that is greater
than 0. I used the following:
=MIN(IF(B5:W50, B5:W5))
But I am getting an error #VALUE!
What am...
|
November 12th, 2003 06:56 PM
by Dan E
|
2 |
335 |
|
|
Help with formula by
Hooter
Hi
I have been here before and the help was great.
OK
What I need to do is have a formula which transfers scores. I have a main
league
with 42 people on it...
|
November 12th, 2003 07:53 PM
by Hooter
|
2 |
101 |
|
|
Arrow Keys by
Mark Wolfson
For some reason, my arrow keys are now scrolling the
entire sheet instead of moving from cell to cell. How do
I reset them so they move cell to...
|
November 12th, 2003 08:21 PM
by Paul B
|
1 |
446 |
|
|
Import text file drops leading zero by
Derrick
I am trying to import a text file in which the first
column is a 10-digit number. This number has a leading
zero. When it is imported into Excel the leading...
|
November 12th, 2003 09:04 PM
by
|
2 |
392 |
|
|
EAN Check Digit Calculation by
Stephen Brown
Has anyone written a formula to calculate the check digit for a 13 character EAN code from the leading 12 characters? (The 13th is the chaeck digit.)
|
|
7 |
381 |
|
|
|
|
2 |
247 |
|
|
|
November 12th, 2003 10:51 PM
by ManojB
|
5 |
193 |
|
|
Grouping by
Jackie
I have to come up with a count of numbers which fall into
certain ranges: 0 - 1.0, 1.1-4.0, 4.0. Short of sorting
by that field and manually counting, how...
|
|
3 |
106 |
|
|
Excel formulas by
Tina
Help!!! in the past, Excel has always automatically
updated formulas when the values in their cell references
changed. as i am working on excel tonight, i...
|
November 13th, 2003 08:18 AM
by Max
|
1 |
482 |
|
|
Auto form number by
Freshman
Dear experts,
I want to create a form template with a form number. This
number should be unique and never reuse again. For
example, the starting number is...
|
|
1 |
472 |