|
Formula Help
I have a sheet that lists items and sales for each month for the last 24
months.
Example
Description, Oct04, Nov04,....Aug,06,Sep06
Item001, 1, 0,.....,0,0
Item002,
Item003
I need a formula to determine the last month the sales number was positive.
For Item001 the result would be Oct04.
Grant
...
|
2 |
22.09.2006 01:25:01 |
|
|
Calculate Number of Months Weeks and Days Between Two Dates
Greetings:
Here's a problem that I've yet to figure out.
I'm trying to determine the number of months, weeks and days between
two dates to determine what the cost of a rented item will be, when the
vendor offers a discount for monthly rates over weekly rates over daily
rates. The standard pricing is always with the assumption that a month
is thirty (30) days, a week is seven (7) days, a...
|
5 |
22.09.2006 00:47:40 |
|
|
Array formula and multiplying conditions
I have a large worksheet and I'm trying to pull some specific information
out of it, and I'm not getting the numbers I expected- so I think there is
something wrong with my syntax. I'm hoping that someone can help point out
my error. As the actual references are quite long, I've shortened them here
to just show the logic, to determine if the logic itself if bad
={sum((if(A1:A30000 =
D7,1,0...
|
7 |
21.09.2006 23:33:56 |
|
|
function to give the number of hours
I need a function that will result in the number of hrs between two times. If
there is no data, then blank. How do I get the result in C1 as in below?
a1= "9-15-06 8:00 PM" b1="9-16-06 05:30 AM c1= 9.5...
|
4 |
21.09.2006 23:03:01 |
|
|
Copying Excel Formulas
I have a spreadsheet of data that is set up kind of like a form in that, for
most of the data, I have 3 blank columns separating between each record. I
am trying to simply pull the data into another sheet using a formula that
references the cell in the original sheet.
Is there a way for me to copy the formulas across to where it only picks up
every fourth column?...
|
2 |
21.09.2006 22:29:07 |
|
|
Underline with accounting format
Preface: If you use the accounting format and the underline you get a great
underline that is just a little less than the width of the cell.
Problem: It does not underline the right parenthesis in negative numbers.
Question: Is there any way to create a customized version of the accounting
format that will to go all the way to the right and go under the right
parenthesis for negative n...
|
5 |
21.09.2006 22:27:29 |
|
|
SUM(IF(multible conditions))
I need to know how to write a conditional sum (or DSUM or other) formula
involving multiple worksheets(wks1-5) in a workbook.
Here is my failed attempt in wks1:
=SUM(IF(wks2DateColumn>=B38 and <=C38,"",wks2AmtColumn))
wks1 contains a StartDate column and an EndDate column; the two dates in one
row defines a Quarter calendar(spanning down 20 years). The next cell in
each row will co...
|
3 |
21.09.2006 21:58:02 |
|
|
Which Statistical Analysis Should Be Used
Hello All,
I am hoping someone could help me in deciding what statistical function
should be used if I want to know cumulative amounts.
For example, if I am looking at reports that are made daily by my team.
I would like to know how many reports are being added daily. Btw, I
would be working within an Excel spreadsheet.
So I might see for example, 29 reports entered one day, 35 re...
|
1 |
21.09.2006 21:55:23 |
|
|
Single text file imported to multiple worksheets
I have a single text file with many different pieces of data that I'd like
divided into individual worksheets. The text file looks like this:
Server - test1 O/S Version
oracle5 HP-UX B.10.20
oracle7 HP-UX B.10.20
Server - test 2 O/S Version
whmz HP-UX B.10.20
Server - test 3 O/S Version
saturn ...
|
3 |
21.09.2006 21:42:01 |
|
|
excel formula
I would like to set up a spread sheet. My objective is to assign a cell(eg
A1) a value, say 50, but also to have that value hiden.
Then if i was to type in 40 into cell A1 it would work out the difference
for me i.e. the cell(A1) would show -10. Or alternatively if typed a value
say 60 into cell A1 the cell would display +10.
Is this possible? If so how? Many thanks...
|
2 |
21.09.2006 21:20:01 |
|
|
Nested If statements
Can you help please?
I have a table where each student has sat 2 papers. If they get 50 or
over it is a pass, if they get 80 or more they distinction and if they
get less then 50, it is a fail. This works fine if they pass or fail
both papers, however if they fail one but get a distinction in the
other, my formula is not working.
thank you
Roni
...
|
4 |
21.09.2006 21:13:09 |
|
|
how can I add time in excel to determine how long something took?
if I put down 7 am in one column and 4:49 pm in another, what formula do I
use to determine total time (9.81 hours)...
|
3 |
21.09.2006 21:09:02 |
|
|
Hiding error message
I have a cell that displays an error message #DIV/0! (divide by zero error).
How do I hide this error message?
I tried Conditional Formatting: Formula Is =ISERROR (the cell that contains
the zero). But I get an error message that reads "You may not use unions,
intersections, or array constants for Conditional Formating criteria." The
cell that contains the zero is on an adjacent worksh...
|
4 |
21.09.2006 21:08:22 |
|
|
How do I keep someone from changing page breaks on a sheet that i
How do I keep someone from changing page breaks on a sheet that is protected....
|
1 |
21.09.2006 20:43:02 |
|
|
Problems with IF statement
Unfortunately Excel won't accept below formula and I can't figure out why.
Any suggestions? I'm using a European version so I know the ; dividing the
criterias are correct.
IF(B12<B4;0;IF(B12>=B4;IF(B12<=C4;((((B12-B4)/(C4-B4))*0,25)+0,25)));IF(B12>C4;IF(B12<=D4;((((B12-C4)/(D4-C4))*0,5)+0,5)));IF(B12>D4;1,0)
Many thanks in advance.
...
|
4 |
21.09.2006 20:37:36 |
|
|
How do you add a group of cells by highlighting them?
...
|
2 |
21.09.2006 19:59:41 |
|
|
My Excel 2000 Sheet never hides even after I save
In excel 2000 sheet when I hide and save then open it shows as unhiden
although I have hided is there solution to this?...
|
2 |
21.09.2006 19:58:11 |
|
|
Create macro to filter on multiple criteria
I have 6 columns in my worksheet which are grouped into 3 pairs of columns.
Columns A, C and E are the current data for a given product and Columns B, D,
and F are the previous data. For instance, Column A result for cell 1 is
"January" and Column B result for cell 1 is "March". Similarly for the other
two sets of columns.
What I want to be able to do is filter to just those rows w...
|
7 |
21.09.2006 19:51:01 |
|
|
excel formulas
I am trying to create an excel spreadsheet with a multiple function equation
at the end, but I cannot seem to get it to work properly.
Here are the rules for the equation:
Rule #1: true if the customer's net worth is greater than $500,000, false
otherwise
Rule #2: true if bidder's CCAR rating equals 1 and bidder's stress risk
class equals 1, false otherwise
Rule #3: true if the bid...
|
3 |
21.09.2006 19:48:01 |
|
|
Zero Value Ranked
I need to rank the "% of inc" column but I get an error message (#N/A) on the
ones that have 0%. This is the formula I'm using:
=IF(H6=0,"",RANK(H6,$H$5:$H$15)). I've also tried
=IF(G21=0,"0%",(C21-G21)/G21). What would you suggest?
% of inc Rank
-100% 6
0% #N/A
300% 1
-33% 3
-100% 6
0% #N/A
-100% 6
0% #N/A
-50% 5
50% 2
-33% 3
...
|
4 |
21.09.2006 19:20:02 |
|
|
combination functions in one cell
Hi
I am trying to create a combination function. I want to first sum specific
cells in a column and then if the sum is a certain value, I want the cell to
say "not met" instead of the sum.
For example, I want to put the formula into cell A1. I want to sum A2:A5.
The value is 10. Instead of the true value, the cell should say "not met".
However, if the value is anything other tha...
|
7 |
21.09.2006 19:15:25 |
|
|
Which Function do I use?
Hi, I have two worksheets that have data in them and they are both in one
workbook. Sheet1 contains unique group names in B1:Z1 and unique user names
in A2:A256. Sheet1 is used to put an "X" in each cell where there is a user
that has access to a group(ex. B4 has an "X" because that user has access to
that group). In Sheet2, I have the group names going down Column A, and I
have the user...
|
9 |
21.09.2006 19:14:02 |
|
|
Vlookup - Identify Label - Excel Programming Bug
Hi. I use VLOOKUP formula's every single day - I use them A LOT !
My current machine has Ms Excel 2003.
A normal Vlookup formula looks like :
=VLOOKUP(A2,Sheet1!$A$16:$B$21,16,FALSE)
Prior to Ms Excel 2003, I have NEVER had a problem with Vlookup formula's.
HOWEVER.....Some "Genius" Programmer at Excel has bugged the Worksheet
command.
Now, when I go to type "FALSE" at the end of...
|
6 |
21.09.2006 19:09:43 |
|
|
DATEDIF
I used the following formula to calculate the difference between two dates:
=DATEDIF(A2,B2,"y") & " years, " & DATEDIF(A2,B2,"ym") & " months,
"&DATEDIF(A2,B2,"md") & " days"
01/01/2006 28/02/2006 0 years, 1 months, 27 days
01/01/2006 31/01/2006 0 years, 0 months, 30 days
Which is ok but I would want the result for the first example to be 2 months
and for the second example 1 month.
...
|
6 |
21.09.2006 18:30:02 |
|
|
count on multiple conditions
I'm trying to perform a count based on two columns and two conditions. I've
searched the forum and found several options but can't get any of them to
work. Will "countif" not work with date?
Here's what I'm doing:
A B
neutral 8/1/2006
positive 8/1/2006
negative 8/5/2006
I want to ...
|
7 |
21.09.2006 17:34:02 |