|
|
calculator Errors by
Kat and the Calculator
When I enter an equation in c1 such as: =product(a1,b1), when a1 is 1000 and
b1 is .10, the answer in c1 should be 100, but it comes out to 102.04. ...
|
|
3 |
91 |
|
|
|
October 9th, 2005 03:58 AM
by Alex
|
5 |
153 |
|
|
create a conditional formula by
Matt H.
Trying to create a formula that when depending on what word is selected from
a list I created, then another list will appear in that cell
|
October 9th, 2005 03:57 AM
by Max
|
1 |
181 |
|
|
IFSum(Vlookup... by
J Shrimps, Jr.
Need to divide a value in a column by a set of
running sum values in an adjacent column.
Data looks like this:
Product Month Bal RemBal ...
|
October 9th, 2005 02:52 AM
by Biff
|
7 |
185 |
|
|
|
|
1 |
234 |
|
|
|
|
2 |
167 |
|
|
|
|
2 |
134 |
|
|
|
|
2 |
131 |
|
|
vlookup returns column to the left by
Brisbane Rob
I thought this would be easy but still can't get it. How do you get a
vlookup to return a value from a column to the left of the array?
Thanks
--
Brisbane...
|
|
3 |
131 |
|
|
|
|
1 |
114 |
|
|
cell text completion by
nospam
Hi,
I am making an index of worksheets tat I use for my pupils.
When I type in some cells excel offers me some text that is in previous
cells in the...
|
|
1 |
104 |
|
|
visual basic by
jiwolf
I have a file where one of the worksheets is set to invisible. ( 0 -
xlSheetHidden). how ca I switch it to visible? every time I try to change it
a warning box...
|
October 8th, 2005 09:12 PM
by jiwolf
|
2 |
119 |
|
|
|
October 8th, 2005 08:11 PM
by S2
|
4 |
157 |
|
|
|
|
1 |
157 |
|
|
|
|
1 |
159 |
|
|
sum with 2 criteria by
Dave
With the below eqn do the dates have to be a cell reference or is it possible
to use a specific date?
One...
|
|
2 |
130 |
|
|
Highest Score for each Test by
abqhusker
Is there a formula/function to to this? Each student get 3 attempts at
a test and I take the highest score. I want a formula that will display
the highest...
|
|
4 |
120 |
|
|
|
|
0 |
233 |
|
|
|
October 8th, 2005 04:50 PM
by Neil
|
2 |
106 |
|
|
|
|
1 |
134 |