|
|
Nested conditional statements by
Shane Devenshire[_3_]
Hi,
Please put your questions into the body of the post. It causes problems in
some web browsers.
In Excel 2003 you can do 7 levels of nesting and in 2007...
|
|
0 |
87 |
|
|
how do i format by
How do I format this in my excel wrk sht
value of $21,480 and gain/loss of $4,080 to currency style format with
decimal poistions in excell
|
|
2 |
97 |
|
|
Vlookyp fails due to space at the end by
Elton Law[_2_]
Dear Expert,
I need to vlookup following items and match the fields ...
Basically, this task is easy and straightforward.
However, system generated file will...
|
|
2 |
174 |
|
|
Nesting Limit 2007 by
bbal20
I was under the impression that excel 2007 allowed more than 7 nested
finctions or up to 64, but I continue to get an error that says
"..........uses more...
|
|
5 |
102 |
|
|
How to divide array formula? by
Guntars
Hello every one,
I got this array:
{0,0,1,1,0,1,1,0,1,1,1,1}
Is there a way to SUM every 3 numbers?
Desired result:
SUM (0,0,1)
SUM (1,0,1)
SUM (1,0,1)
SUM...
|
|
2 |
108 |
|
|
|
|
4 |
146 |
|
|
Multiple IF formulas by
Dmiller
I am trying to create formula in cell L2 that reflectes 3 bids. The formula
I am use works at 2 levels not 3. This is the formula I am using...
|
|
8 |
116 |
|
|
Virus Check by
Terry Bennett
How do I turn off the automatic 'virus check' that runs each time I open an
Excel file?
Thanks.
|
|
3 |
95 |
|
|
|
|
7 |
126 |
|
|
Nested conditional statements by
Harlan Grove[_2_]
gcotterl wrote...
I've having difficulty following what parts of a formula are triggered
if the result of each IF statement is...
|
|
0 |
93 |
|
|
Nested conditional statements by
David Biddulph
Look in Excel help for the IF function.
--
David Biddulph
gcotterl wrote:
I've having difficulty following what parts of a formula are triggered
if the...
|
|
0 |
112 |
|
|
Problem Please Help Me by
Richard
I created a small database using Excel, this file has been running for
serveral months now without a problem. Today, I went to enter in information
and in...
|
|
4 |
84 |
|
|
|
|
4 |
111 |
|
|
|
|
3 |
80 |
|
|
Using VLOOKUP to look up info from Access by
Michelle
Is there any way I can use the VLOOKUP function in Excel to pull in
information from Access and make calculations off that info? It would be
helpful if I...
|
|
0 |
95 |
|
|
|
June 7th, 2009 04:34 PM
by Bill
|
2 |
92 |
|
|
|
June 7th, 2009 02:49 PM
by Joel
|
1 |
100 |
|
|
|
June 7th, 2009 02:47 PM
by Joel
|
1 |
114 |
|
|
Multipling 2 columns by
Tami
hi.
How can i multiply two columns and put result in one cell?In the example
below i would want $110 to appear in cell A1
example
units ticket
2 ...
|
June 7th, 2009 01:59 PM
by Max
|
9 |
209 |
|
|
|
|
4 |
122 |