|
|
|
September 9th, 2009 11:55 AM
by driller
|
2 |
90 |
|
|
|
September 6th, 2009 06:04 PM
by T. Valko
|
5 |
107 |
|
|
|
December 14th, 2005 06:59 PM
by CLR
|
4 |
104 |
|
|
=IF(Master!R6=6, ROW(),"") by
Steved
Hello from Steved
=IF(Master!R6=6, ROW(),"")
The above formula shows #VALUE! as the cell has no value
in it
Please can I expanded on this formula so the...
|
August 22nd, 2004 05:47 AM
by Steved
|
2 |
55 |
|
|
=IF(Master!R7=2, ROW(),"") by
Steved
Hello from Steved
I have this formula in Col A:A =IF(Master!R6=2, ROW(),"")
Starting in Row 6 R6 is Row 6 and =2 is Sheet2
I have the below formula in col's...
|
August 20th, 2004 07:36 AM
by Steved
|
4 |
84 |
|
|
=IF(NOT(ISNA(VLOOKUP Function by
CWH
I am using Excel 2003
I am trying to produce a summary shett from five differnet worksheets.
I am using the following function...
|
|
2 |
90 |
|
|
=IF(OR question by
Jock
Hi,
Having a problem here. Essentially: In cell B9
=IF(either B6 OR B7=0,"",If(B6B7,"",B6-B7)
Can someone sort this one out for me?
Thanks
--
Traa Dy Liooar
|
August 28th, 2007 05:10 PM
by Jock
|
9 |
139 |
|
|
=IF(SUM(........ by
Connie
This worksheet is going to drive me around the bend!
Anyway, please someone, what is wrong with this formula?
=IF(SUM(J5+J12)=0,"",SUM(J5+J12))
Is it because...
|
September 7th, 2004 09:36 PM
by Connie
|
9 |
93 |
|
|
|
December 10th, 2008 04:04 PM
by TagTech
|
5 |
83 |
|
|
|
|
9 |
77 |
|
|
=if(vlookup for non-unique values by
Javier Benavides
Worksheet 1 Cash
Inv. Amt.
A B
1 13300 $200
2 13300 $.01
3 12333 $2000
4 12333 $.01
WorkSheet 2 Check Hist.
Inv. Amt.
|
|
1 |
85 |
|
|
|
|
1 |
87 |
|
|
=IF??? by
Dewayne
I need to return values in a cell based on the "letter" in
the referenced cell, i.e. if A1="A" then return 33 in Z1.
=IF(A1 "A",33) This is fine up to the...
|
|
5 |
152 |
|
|
=INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR) by
excelrookie
Anyone see the problem with this, it isn't working. I am tring to put all
the results (in columns AF:AR) into a cell, based on the input Z3 (The input
will...
|
|
2 |
148 |
|
|
=INFO("Type_text") by
bed_mail
I appreciate that =INFO("directory") displays the Path of the current
directory or folder.
Is there a similar function to display the user/author or last...
|
|
1 |
60 |
|
|
=INT(0+(1-0+1)*RAND()) wtf? by
Robert Blass
=INT(0+(1-0+1)*RAND())
The "(1-0+1)" part makes no sense...
how can I express the random formula in shortest form?
=INT(0+(2)*RAND())???
I need a 1 or 0,...
|
|
4 |
62 |
|
|
=Large function returns #NUM! by
Bryan Gnidrah
I have the following function to determine the largest value in a range of
data =LARGE(A1:A10,1). It works fine when the data is input manually...
|
February 17th, 2009 09:05 PM
by Pete_UK
|
5 |
69 |
|
|
=LEFT - Cannot Format by
Mirish26
I downloaded over 2,000 entries which contain date and time in one cell
(20060428 3+12+32). I need the date only and in the format: 04/28/06.
I used =LEFT to...
|
|
3 |
76 |
|
|
=LEFT Function by
Tom
Using the function below will allow me to find the 1st character if
separated by a period.
=LEFT(A1,FIND(".",A1)-1)
For instance, it will provide me the...
|
May 26th, 2004 04:47 PM
by Tom
|
6 |
120 |
|
|
=LEFT(J16,1) by
Kathi
I have a cell that contains the following in column J
ZD5, MNH,IX,WQ
I need to have the first letter of the first group in column K so I put the
formula and...
|
|
5 |
66 |