|
|
LOOKUP/IF Formula Help!! by
DKinNorthCakalacki
I have ben trying to write a formula that will deliver a response based on
where the inout fits within a range.
In short, say Cell A1 = 95. Based on that...
|
|
1 |
72 |
|
|
|
August 27th, 2008 04:52 PM
by Pete_UK
|
9 |
148 |
|
|
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 |
94 |
|
|
|
August 27th, 2008 04:14 PM
by PMo
|
3 |
88 |
|
|
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 |
152 |
|
|
countaif by
A.Mourice
plz. i need a help.
How can I use countaif with many conditions or any similar formula?
|
|
4 |
106 |
|
|
Finding lowest price by
Steve M[_4_]
I'm hoping someone can help me with a formula that will determine from
4 non-consective columns, ie, F,H,J,L, the lowest price of the four
and place the...
|
August 27th, 2008 03:04 PM
by rajesh
|
1 |
60 |
|
|
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 |
60 |
|
|
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 |
54 |
|
|
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 |
58 |
|
|
free movies by
[email protected]
http://www.freemediatv.com/video/992-Meet_Dave_2008_DIVX.html
http://www.freemediatv.com/video/991-VLC_Media_player_Online_test_only.html
http://www.freemediatv...
|
August 27th, 2008 12:24 PM
by Taurien
|
1 |
149 |
|
|
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 |
70 |
|
|
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 |
75 |
|
|
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 |
71 |
|
|
|
August 27th, 2008 09:08 AM
by Max
|
1 |
120 |
|
|
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 |
80 |
|
|
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 |
92 |
|
|
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 |
93 |
|
|
|
August 27th, 2008 04:46 AM
by Max
|
6 |
112 |
|
|
|
August 27th, 2008 04:33 AM
by chris
|
0 |
127 |