


August 27th, 2008 04:52 PM
by Pete_UK

9 
94 


Formula Help by
Lee Ann
I have a worksheet/form which is being used to track time spent on specialty
details in my office. The user needs to indicate which days of the month are...

August 27th, 2008 04:35 PM
by Pete_UK

8 
68 



August 27th, 2008 04:14 PM
by PMo

3 
72 


Automatically Entering Values by
Sanchit
Is there any way to preset some values?
Suppose I entered some values in From A1 to A4 (A1=12,A2=13,A3=14,A=15)
Now I want that when I enter 12 in C1, it...

August 27th, 2008 03:33 PM
by Spiky

4 
129 


countaif by
A.Mourice
plz. i need a help.
How can I use countaif with many conditions or any similar formula?


4 
86 


Finding lowest price by
Steve M[_4_]
I'm hoping someone can help me with a formula that will determine from
4 nonconsective columns, ie, F,H,J,L, the lowest price of the four
and place the...

August 27th, 2008 03:04 PM
by rajesh

1 
36 


Look up, not down by
mckzach
Greetings all,
I want to find a specific value (1) across Row 3, then look UP to Row 1 and
return the corresponding name (e.g. Jim), as below. What formula...


1 
37 


find max.. by
[email protected]
assume we have the following lists...
How can i return max value of "id"?
e.g.
ia1 = 11
ia2 = 8
ia4 = 5
ib1 =7


1 
35 


Variable Range for NPV by
Dkline
I need to calculate an NPV that could start in any given year and end in a
later given year to provide a stream of income.
For example  I have a 30 years...

August 27th, 2008 02:14 PM
by Dkline

7 
43 


free movies by
[email protected]
http://www.freemediatv.com/video/992Meet_Dave_2008_DIVX.html
http://www.freemediatv.com/video/991VLC_Media_player_Online_test_only.html
http://www.freemediatv...

August 27th, 2008 12:24 PM
by Taurien

1 
126 


Ignore NA in a formula when I type it in a cell by
Tyler Manhattan
=IF(F60,10,0)+IF(H6=1,10,0)+IF(I6=1,10,0)+IF(Q6=0,10,0)+(K6*20)+(M6*20)+(O6*20)SUM(R6+S6)
When I put a NA into cells K6, M6, O6, R6, S6, it won't...


4 
53 


Cell Reference by
Taurien
Hi!
I need to know that can we use a particular cell in a formula again and
again. And my excell 2003 is showing numbers in columns but in earlier
versions...

August 27th, 2008 09:44 AM
by Taurien

4 
54 


HLOOKUP by
Freshman
Dear experts,
In sheet "Team", cell N3 is a lookup value. In sheet "Group", array table is
E9:L42 and row index is 42. So, in sheet "Team" cell N4, I set a...


2 
53 



August 27th, 2008 09:08 AM
by Max

1 
50 


Using CTRL to select cells for a formula by
Elgee
Hi 
I tried to search for help on this one before posting  but wasn't sure how
to search for my answer if that makes sense.
Essentially  I work with a...


2 
55 


Timesheet Function by
Ricardo
I have the following in a spreadsheet for working out time work. Everything
adds up into little columns, however when this entry is put in, it produces a...


2 
62 


Index/Match by
Esradekan
I have a workbook for wages.
Each staff member has a sheet of their own calculating gross amounts
paid.
Tax is deducted from this amount but is complicated by...


3 
77 



August 27th, 2008 04:46 AM
by Max

6 
88 



August 27th, 2008 04:33 AM
by chris

0 
82 


if statements returning dates by
Clinton
i have the following formula to give a 2 day cycle for production which will
skip saturdays and sundays. can it be made to miss other days such as public...


4 
64 