|
|
|
April 12th, 2007 10:29 AM
by DavidS
|
0 |
82 |
|
|
Converting more than one currency by
GCC
I have a spreadsheet with a list of buy prices on, however we buy from
different countries so therefore all of the buy prices are in different
currencies. I...
|
|
5 |
95 |
|
|
|
|
1 |
110 |
|
|
Help with Formatting cells by
Jose
How do I format a cell to not show 0 as being negative? Could it be the
formula I'm using? This is the formula in cell L321 ...
|
|
3 |
105 |
|
|
conditional formay date maturity by
Frank[_3_]
Hi, I will try my best to explain. I need to have conditional formatting as
such:
3 cells in adjacent columns. first has name, second has text missed...
|
April 12th, 2007 07:26 AM
by Joerg
|
1 |
112 |
|
|
|
|
7 |
118 |
|
|
linking cells by
stremetzky
On sheet1 I have the following data:
A B
111 NAME_1
222 NAME_2
333 NAME_3
444 NAME_4
.... ...
|
|
3 |
122 |
|
|
Please help for FV and XIRR function. by
RushatiINDIA
Problem 1:
Rate of Interest (ROI): 7.50% - Compounded Quarterly
Annual Rate Compounded: =FV(7.50%/4,4,0,-1)-1 ie 0.0771
Minimum Investment=Rs. 10 per...
|
|
3 |
136 |
|
|
Formula for extracting data from a string by
LFM[_2_]
I have a spreadsheet of UNC drive mappings. I need to extract out
just the name of the server from the fields.
Example:
\\SERVER01\user
\\SRV02\user
I need...
( 1 2)
|
|
10 |
131 |
|
|
|
April 12th, 2007 02:05 AM
by Aaron
|
0 |
81 |
|
|
Array Formula Not Calculating by
Alex
I tried the following two formulas, which should be producing the same value,
but I either get a blank cell or N/A. I have copied this formula and am...
|
April 12th, 2007 01:52 AM
by JMB
|
1 |
76 |
|
|
|
April 12th, 2007 01:28 AM
by JMB
|
4 |
91 |
|
|
moving cells by
[email protected]
I want to move cells from one page to another by using a formula, or
basically without having to manually enter then numbers. I am sure
there is an easy way to...
|
|
2 |
90 |
|
|
|
|
3 |
132 |
|
|
tab.colorindex linked to cell color by
Mike
I am running Excel 2003 SP2 and have been trying to figure this out for 2
days. I have reviewed all of he postings and cannot get this to work. I have
a 4...
|
April 12th, 2007 12:44 AM
by Mike
|
2 |
87 |
|
|
If/Then functions in Excel by
Sean
I am trying to write a spreadsheet for tracking man-hours worked over a pay
period.
What I want to do is sum the fields for the first week, and if the total...
|
|
1 |
72 |
|
|
External Database Source by
ericat04
I have one spreadsheet that contains 6 or 7 Queries that are all directed
toward the same data source "MB7 data - 2006". These were needed to pull
figures...
|
|
0 |
84 |
|
|
IF formula by
casdaq
I need to create what I would think would be an IF formula for quite a large
group of measurements. Here is an example of what I am working with...
A ...
|
April 11th, 2007 11:14 PM
by casdaq
|
4 |
85 |
|
|
Look up and return text values by
plb2862
Hi,
I have two tabs in workbook
Tab "Blank" which contains a table with two columns "A" & "B" and rows
"42:69." In column A you place an "x" to signify the...
|
April 11th, 2007 10:34 PM
by Max
|
3 |
111 |
|
|
count if by
[email protected]
how do i get the count if function to count based on certain concrete
conditions...if cell a1 = condition a and = condition b then add 1
to count...
|
|
1 |
101 |