|
|
|
|
2 |
343 |
|
|
|
|
2 |
310 |
|
|
Adding variable number of columns by
fabio
Hi
Using Excel 2003 I want to create a formula which will add a varing number
of columns together depending on the entry in a particular cell, for a...
|
|
8 |
533 |
|
|
Average with #DIV/0! by
TG Engel
I'm having a problem with an Average formula. When I use a solution to a
similar question =AVERAGE(IF(ISNUMBER(B8:M8),B8:M8,FALSE)), it eliminates the...
|
|
4 |
299 |
|
|
|
|
6 |
595 |
|
|
condditional farmulation by
RAMAN
sir, i want to do in excel such type of farmla through we can not leave blank
cell or enter without giving number.
like :
1
2
4
if we can not enter 3 than...
|
|
2 |
254 |
|
|
Remove weekends by
rhhince[_2_]
I have 2 dates and time:
5/21/2010 11:34 is in A2
5/25/2010 11:34 is in A3
If I subtract them, I get 4 days in cell A4.
I would like to subtract the weekends...
|
|
2 |
262 |
|
|
|
|
1 |
334 |
|
|
|
|
106 |
3,956 |
|
|
|
May 22nd, 2010 01:49 PM
by Max
|
2 |
334 |
|
|
Overlap graph multiple axis by
aquaxander
Hi,
I am aware of secondary axis. But is it possible to plot more than 2 types
of data? So, for example I want to plot over time (so week1, week 2, etc =...
|
|
1 |
222 |
|
|
|
|
6 |
215 |
|
|
putting a date in an if statement by
pat67
When i write an if statement taht says this =IF(J26/1/2010,"N/A",J2),
it always comes up false. How do make it see the date?
|
|
5 |
229 |
|
|
|
May 22nd, 2010 12:33 AM
by Max
|
13 |
520 |
|
|
Indirect.ext by
Doug
How would I need to type this in? I have tried this several ways. This is
what I have currently and it gives me an
error "A formula in this worksheet...
|
|
1 |
245 |
|
|
|
|
2 |
185 |
|
|
IF Function by
casdaq
I have this formula currently set up...
=VLOOKUP($A14,$B$7:$J$10,5)*W14
but I needit to not reflect the calculation if W14 has a "-" dash in the
cell. I've...
|
May 21st, 2010 08:37 PM
by jayray
|
4 |
216 |
|
|
|
May 21st, 2010 08:36 PM
by jayray
|
2 |
229 |
|
|
|
|
1 |
261 |
|
|
|
|
7 |
298 |