|
|
unions, intersections or array constants by
Loadmaster
I am trying to make a conditional formatting formula in cell A3 that goes
something like this =$AK$2=JAN, MAR, MAY, JUL, SEP, NOV to format Blue and...
( 1 2 3)
|
|
23 |
198 |
|
|
Moving Info from onw sheet to another by
Mike
Hi All,
I am trying to use 1 sheet for my data storage then sort that info to
another sheet that looks only for a value I am looking for. Here is a example...
( 1 2 3)
|
January 10th, 2008 09:27 PM
by Mike
|
23 |
238 |
|
|
DATE() Month in Letter NOT Number by
Neon520
In Date(year,month,day) function, all need to be number, what if I have month
in letter, how can I use date function?
I've tried a different way by using if,...
( 1 2 3)
|
|
23 |
244 |
|
|
next to impossible by
IF function incompetent[_2_]
I am trying to find the percentage at which the pay rate is equal to what
percentage based on a two factors 1) what pay grade it falls into and 2)
where it...
( 1 2 3)
|
|
23 |
190 |
|
|
Help with IF function please 03.08.08 by
Essjay
Can anyone help with syntax for an IF formula as under:
If E17=E (for exempt) then F17=$0.00 but
If E17=V (for VAT) then F17=G17*17.5%
I have an invoice on...
( 1 2 3)
|
March 12th, 2008 05:50 PM
by Essjay
|
23 |
179 |
|
|
Adding Random Numbers by
Gary''s Student
I need to add up 23 independent random numbers. My first try was:
=RAND()*23
This proved to be insufficient since it really only added the same random...
( 1 2 3)
|
|
23 |
247 |
|
|
Difficult Average Function by
Connie Martin
I am stumped. How in the world do I write this formula?
In a cell, I want it to find the date in A9 in A42:A5000 and then average
the numbers in J42:J5000...
( 1 2 3)
|
|
23 |
208 |
|
|
|
|
23 |
300 |
|
|
Formula Function by
SM_NCSW
I am trying to calculate a progressive rate for water use charges:
8500=$40,
8501 up to /1000
21000 up to /1000
50000 @6.00/1000
Col.A...
( 1 2 3)
|
|
23 |
268 |
|
|
Date issue to automate calendar by
Babs in Ohio
I have a start date of 11/1/2008 - What I want to populate is a table that
has columns for Jan-08, Feb-08, Mar-08 etc begining with January ending with...
( 1 2 3)
|
|
23 |
269 |
|
|
SUMPRODUCT - 2 Criteria by
Sam via OfficeKB.com
Hi All,
If possible, I would like to use SUMPRODUCT to achieve the following:
Two ranges - H$5:H$41 and I$5:I$41. Both ranges have some blank and empty
text...
( 1 2 3)
|
|
23 |
218 |
|
|
Excel Date Format by
ldan122000
I would like to use a formula to display the following:
"Name of Report" October 1 - 15 as the date, then on the next sheet,
"Name of Report" October 16 -...
( 1 2 3)
|
|
23 |
214 |
|
|
Named Ranges by
Epinn
Note: This is a continuation of a previous discussion which you don't really need.
Dave,
I did an experiment. I opened a brand new workbook. On Sheet1, I...
( 1 2 3)
|
October 16th, 2006 07:27 AM
by Epinn
|
23 |
228 |
|
|
|
March 16th, 2007 07:37 PM
by KL
|
23 |
419 |
|
|
|
|
23 |
406 |
|
|
Determine if a number is prime by
Nia
I saw a message where someone suggested using "=ISPRIME(num)".
I want to make this statement =IF(IsPrime(num),"Prime","Composite").
When I enter it in I get an...
( 1 2 3)
|
|
22 |
302 |
|
|
Help a teacher?? by
Tim K.
Well, her boyfriend anyway.
I'm building a grade sheet for my girlfriend and linking the letter grade
outputs to a report card template in Word and I need to...
( 1 2 3)
|
August 23rd, 2004 10:23 AM
by Tim K.
|
22 |
297 |
|
|
VLOOKUP with 2 Criterias by
Roni
Let's say I have the following information in sheet1:
Serial # Asset code Location
1 A =vlookup(???)
2 B
3 C
In...
( 1 2 3)
|
|
22 |
372 |
|
|
Neeeed Help!! by
luckyt22
Ok so here is my problem. I have a report i need to do every month
based off of data. I have an excel sheet for the whole year of 2005 so
far. Each entry...
( 1 2 3)
|
|
22 |
305 |
|
|
Using Countif across multiple sheets by
shades
I don't think you can use COUNTIF across sheets. Here is the
alternative:
=COUNTIF(Sheet2!A1,"0")+COUNTIF(Sheet3!A1,"0")
Guy Hoffman wrote:
*I am...
( 1 2 3)
|
|
22 |
796 |