|
too many nested IF functions
I have created the below IF formula but it will not let me go any further.
=IF(D3="Especial",(((H3-0.12)*1.4)+0.3),IF(D3="Nacional",(((H3-0.12)*1.4)+0.3),IF(D3="Llam.
Interna",(((H3-0.12)*1.4)+0.3),IF(D3="Internacional",(((H3-0.3)*1.4)+0.3),IF(D3="Núm.
Vodafone",(((H3-0.12)*1.4)+3),IF(D3="Mensaje
Corto",(H3*104),IF(D3="Realiz.Vodafone World",(H3*1.4),IF(D3="Recib.
Extranj",(H3*1.4)))...
|
5 |
29.09.2006 17:56:02 |
|
|
SMALL function if > 0
How do I create a function that looks at a column of numbers and give show
the smallest number that is greater than zero? I tried a nested if function
but it doesn't give me the correct answer.
--
Louis...
|
6 |
29.09.2006 17:46:02 |
|
|
How can I set up a series with letters and numbers together?
I am using Excel 2003. I am trying to set up a series of claim numbers they
look something like this: 0129H01, 0129H02, 0129H03,..., 0129H99. Is there a
fast way for me to create a series in excel for this list of claims instead
of just entering them all in one by one?...
|
4 |
29.09.2006 17:05:07 |
|
|
Converting text to formulas
I am trying to streamline a mathematical optimization program that I wrote in
Excel with a macro. Say that I have typed a formula into cell A1 as a text
string, such as "x^2+10*x^4". Next I have renamed cell B5 as "x". I want
the cell C5 to convert the formula written as a text in A1 to the formula
"=x^2 +10*x^4" which will reference cell B5 and calculate it without having
to manually...
|
8 |
29.09.2006 17:00:53 |
|
|
Copying figures from Access to Excel
I am running Office 2002. When I tried to copy figures from a crosstab
query in Access into Excel, the figures come in as text. This doesn't
happen when using Office 2000 (on another PC). There is a convoluted
way of converting the text to figures. However, is there a way of
preventing this happening i.e. that the figures would copy to Excel as
figures. Perhaps some setting need to be change...
|
1 |
29.09.2006 16:49:45 |
|
|
Should I use COUNT IF? from one sheet to another
I want to count the totals of various text strings together from sheet 2
eg
on sheet 2 , I want to know the total of Jack, John, Mary & Kates scores as
a whole (each appear atleast 10 times in the different rows)
There are hundreds of rows with different names but need the totals of these
particular 4. The names are are in column D and the totals in column H
I need to show the...
|
2 |
29.09.2006 16:33:01 |
|
|
Edit Drop Down List
I have created a drop down list in Excel 2003 Ver 11.5.
Now I want to edit, or add to the list. HOwever I get a error message that
states the user has restricted values that can be entered into this cell.
I have gone to Data - Validation, and tried to see my list there, or add to
the list there but that does not work for some reason either.
Where am I going to in editing my drop down list...
|
2 |
29.09.2006 16:23:12 |
|
|
AVERAGE(with complicated range -blanks..)
I got som values in Range("A10:A100")
There are some empty cells inbetwin
The 'list' grows but only inbetwin row 10 and row 100
There are values before and after 'my' range that i dont wana use
So how do i make a AVERAGE-formula for the 6 last values in my range?
I no how to find the last not emty ROW in my range:
MAX(IF(A10:A100<>"";ROW(A10:A100)))
But how to find 6 not empty ...
|
8 |
29.09.2006 16:14:01 |
|
|
sorting a column with numbers and text
I am trying to sort a column with numbers and text eg;
..75-2-mbv-167
..75-2-mbv-168
2-2-mdv-004
1.5-1-mbfv-002
1.5-1-mbfv-001
these are identification tag's for valves.
I have over 2700 items with differnent code numbers!
I need help !
--
Ford35...
|
6 |
29.09.2006 16:02:09 |
|
|
Vlookup not working
I am using VLOOKUP with a range of part refs some are numeric only, some are
alphanumeric.
My lookup is working fine with the alphanumerics, but not the numerics.
Please help. I have tried formatting all refs in each worksheet as text to
no avail....
|
2 |
29.09.2006 15:50:13 |
|
|
macros for autofill
I need a macros to autofill rows. I am working on one now but have a few
problems. I have one spreadsheet that has a row for each employee for each
payperiod. It has the employee name, check number, date, hours worked,
vacation sick, pay etc, earnings. The hours worked may be in 3 column
depending on if it is regular pay, overtime 1 pay, overtime 2 pay, and
commission - (which is an ...
|
1 |
29.09.2006 15:44:02 |
|
|
SUMPRODUCT - Count Previous Month
=SUMPRODUCT((INPUT!$B$2:$B$20000 = A2)*(INPUT!$A$2:$A$20000 =
MONTH(NOW()) -1))
I would like to count the number of records from the previous month
regardless of what month it is.
So if I run this in October, it will check column A, and give me a count of
all the records for September.
I don't think I am doing this correct.
...
|
4 |
29.09.2006 15:42:57 |
|
|
Using VLOOKUP, IF and RIGHT functions together
Oh great ones,
Where to begin. I want to combine IF to test what RIGHT returns and based
on the answer, point it to VLOOKUP to return a cell content (which is a long,
complicated path).
In English, IF (right(cell, 3) returns "HPT", then VLOOKUP (cell with P&L#,
Security!PTSec,2, FALSE), (if (right(cell,3) returns "HFT", then Vlookup
(cell with P&L#, Security!FTSec, 2, FALSE), IF (righ...
|
4 |
29.09.2006 15:31:03 |
|
|
If Function Assistance
I have a commission statement that I need to set functions in.
I need to say if cell C30 is less than or equal to 20, then C31=$40, if C30
is between 21-40, then C31 is $60, if C30 is between 41-50, then C31 is $80,
and if C30 is greater than or equal to 51 then C31 is $100.
Please Help!!!...
|
4 |
29.09.2006 15:30:01 |
|
|
Array Formula with Concatenate and If
I think that using an array formula will solve my little problem, but I only
understand a little about them, and the formulae are only returning blanks.
I have a table of data, that I wish to rearrange into a grid based on
entries into 2 columns with restricted values allowed.
The data is in the format, and the headers define the Named Ranges
ID# Description Y-axis X-axis
-...
|
3 |
29.09.2006 15:24:02 |
|
|
Reference a list to perform a function in Excel
Excel 2003
I have several similar list of products with the number of each product sold
on several sheets. The first sheet would be a total for everyone and
subsequent sheets are individual teams. I would like show what percentage
each team is contributing to the total number. The trouble being, each list
is continually changing and the products dont fall in the same rows for each
shee...
|
1 |
29.09.2006 15:03:02 |
|
|
Finding the last cell to enter a string and/or a sum formula
I am working on a macro that finds the last cell in the worksheet and enters
a specific number. The next column needs to be totaled at the last cell.
How can I incorporate a formula in the macro that will put the sum in the
cell for me?
--
Thanks a bunch!
rojobrown...
|
5 |
29.09.2006 15:01:03 |
|
|
Need blank formula cells rather than 0's
I'm doing a simple spreadsheet with a few child sheets that point back to a
parent sheet with an overview of information. I've set of cells in the
parent sheet to simply look at another cell in the child sheet and copy it
across (eg =Sheet2!B3). The problem that I've got is that when cell B3 in
sheet 2 is blank it the cell in the parent sheets comes out with 0. Can
anyone tell my how ...
|
4 |
29.09.2006 14:43:02 |
|
|
Naming same cell in different worksheet with 2 value changing on e
Hi!
I have a problem?
i am trying to name a cell on my sheet1 = t1wk1 and on sheet2 i would like
that cell to be name t2wk1 and so on....
and after on each sheet i i have sheet1 a1=t1wk1 and a2=t1wk2 and a3=t1wk3
and so on....
NOW ON MY MASTER SHEET!
I need to get the cells to refer to those cell for each team....
Ex: a1 value will be "=t1wk1" , b1 value will be "=t1wk2" and so...
|
1 |
29.09.2006 14:15:03 |
|
|
need help with MY FORMULA
any one out there to help me
MY FORMULA
=` IF
(countif(8:18),:=;="p")=7,"Distinction",IF(countif(C8:G18,"p",,)=5,"Merit",IF(Countif(C8;E8."p")=3,"NOT YET ACHIEVED" )))...
|
2 |
29.09.2006 14:02:02 |
|
|
array function
Please tell me how to make array sum of the product at a formula with
thanks.
--
birdsting...
|
2 |
29.09.2006 13:06:02 |
|
|
SUMIF with external data
I am using a sumif function to sum data in a different file.
If I use the path to external data as x:\share\dir\file\cell..cell it works
OK, but if I replace x: with network name such as
\\nas\share\dir\file\cell.cell, it returns error.
Can anyone please tell me if this is a problem or I am supposed to use a
differnt syntax. I replaced the drive letter with network path in the menu
Ed...
|
2 |
29.09.2006 12:52:01 |
|
|
Flaging Dates
I have a spread sheet that has training certificate dates. Some are pass
dates, others are expiry dates.
I need to be able to flag them up 2 months prior to their expiry dates.
Can anyone help?
Thanks...
|
2 |
29.09.2006 11:46:02 |
|
|
Large excel file
Hi i have a very large excel file which won't open for me - I have
tried to open it about 7 times but it refuses to open - I cannot get
into the file to turn calculation off and as it stands its about 30mb.
thanks
...
|
2 |
29.09.2006 11:23:33 |
|
|
How do I convert dates (09/15/06 or 09/20/06) to month (Sept 06)?
I have a table with data entered by date. I want to sort the data by month.
If I merely format the date to show month-year, the data is still only sorted
by date. How do I convert a date entered as 09/15/06 to a month displayed as
Sept 06?...
|
4 |
29.09.2006 10:23:46 |