|
|
An oddity if not a bug by
Harlan Grove
A1:
=FACT(9)/FACT(6)/FACT(3) returns 84, as it should
A2:
=COMBIN(9,3) returns 84, as it should
A3:
=A1=A2 ...
( 1 2 3)
|
|
21 |
253 |
|
|
The 4th column D to be filler. by
Steved
Hello from Steved
Below I've Columns A,B,C, What I would like please is a formula the would
find the Duplicates, if none found the put the number 1 in...
( 1 2 3)
|
|
21 |
199 |
|
|
Date + 365 in New Column by
ace214
I have a column of dates, F. I want to have the dates plus a year in column M.
I figured out that you can add 365 to a date but I'm not sure how to process...
( 1 2 3)
|
|
21 |
249 |
|
|
|
|
21 |
333 |
|
|
|
|
21 |
152 |
|
|
days of the week formulas by
Bob
I'm looking for formulas that will give me the first Monday and last Sunday
of a period. For example The First Monday of February 2008 would be February
4...
( 1 2 3)
|
March 7th, 2008 10:16 PM
by Bob
|
21 |
210 |
|
|
"IF" Function by
Boblink
Hi, I am using Excel MSOffice Xp (2002) and would appreciate help with the
"if" function. I am trying to create a Retirement formula and running into
all...
( 1 2 3)
|
|
21 |
304 |
|
|
Counting Items by
Jakobshavn Isbrae
How can I count the number of items in a column whose length exceeds zero?
--
jake
( 1 2 3)
|
|
21 |
134 |
|
|
Counting by
Civette
I have a spreadsheet containing thousands of records (each row is a different
record) and 20 different data columns.
I want to count the number of records...
( 1 2 3)
|
July 10th, 2008 09:32 AM
by Pete_UK
|
21 |
164 |
|
|
Need Period After Initials by
Susan
I imported a database into an Excel spreadsheet. The middle initials in the
names don't have periods after them. Is there a wildcard character that I
can...
( 1 2 3)
|
May 15th, 2007 09:45 PM
by Susan
|
21 |
199 |
|
|
Concatenate values IF() by
Nikki
Hello group, we meet again:
I have values returned, in Column W25:41; either a number (formatted
as text) or nothing (""), depending on checkboxes selected...
( 1 2 3)
|
|
21 |
333 |
|
|
IF AND OR functions by
Rondia
I have looked everywhere for help. This should be a simple formula,
but never works for me. I have a main worksheet that I entered dated
data into. I want...
( 1 2 3)
|
|
21 |
297 |
|
|
|
September 4th, 2006 07:56 PM
by Biff
|
21 |
119 |
|
|
One of lifes little mystery? by
JethroUK©
IF function
if you omit the false parameter, the function returns "FALSE"
=IF(A1="Bob",TRUE)
so why doesn't it return "TRUE" so you can omit the true...
( 1 2 3)
|
|
21 |
112 |
|
|
Sum totals based on product name by
jana
I have a large worksheet that has a product name and then in the next cell a
sum, how do I sum only those equal to a specific product name. I have a list
of...
( 1 2 3)
|
|
21 |
195 |
|
|
|
November 19th, 2006 09:38 PM
by Epinn
|
21 |
329 |
|
|
Array help Part 2 by
driller
Almost got it !
from previous question of Luke "Array Help" yesterday, where the checked
answer is :
on...
( 1 2 3)
|
November 24th, 2006 03:49 AM
by Max
|
21 |
273 |
|
|
If Then Dilemma by
Excel Confused
I am trying to solve this problem:
If a value in cell D4 is from 1 to 50 then I want a certain celll to show
$2000 if the value in cell D4 is 50 to 100 then...
( 1 2 3)
|
December 29th, 2006 01:11 AM
by JMB
|
21 |
158 |
|
|
how to count easily by
dribler2
With all formulas i gathered, i am still unable to do what my boss need.
my boss is never satisfied maybe this is the last he will ask me
something like...
( 1 2 3)
|
|
21 |
243 |
|
|
|
|
21 |
245 |