A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
=IF(ISNUMBER(SEARCH("ELB", and more than one text by toto
Dear All, The formula as below is describes a situation which I want to search for the written letter ″ELB″ ,the below formula succeeded...
September 9th, 2009 11:55 AM
by driller Go to last post
2 90
=IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG" by MAHMOUD
=IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") HOW TO ADD MORE PARTIAL TEXT LIKE "ELB" "FLG" OR MORE PARTIAL TEXT TO THE SAME FUNCTION
September 6th, 2009 06:04 PM
by T. Valko Go to last post
5 107
December 14th, 2005 06:59 PM
by CLR Go to last post
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 Go to last post
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 Go to last post
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...
December 1st, 2009 11:03 AM
by RonaldoOneNil Go to last post
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 Go to last post
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 Go to last post
9 93
=IF(test,true,false) only ever returns "true"? by TagTech
A little help please. I have data imported to Excel from a legacy app. Some DOB is a length of 7, e.g. 1012008 and some DOB is a length of 8, e.g....
December 10th, 2008 04:04 PM
by TagTech Go to last post
5 83
=IF(TRIM(RIGHT(D4,1))="X",MID(D4,1,LEN(D4)-1),D4) ? remove error by Muhammad Nasir
plz remove error from the formula? If any one can help. My excel sheet contains values like 561XX, I want to remove the right most X from the text.
June 24th, 2005 10:22 AM
by Bob Phillips Go to last post
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.
December 7th, 2007 05:05 AM
by T. Valko Go to last post
1 85
=IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 by Milky
what is the difference between this two functions?
August 20th, 2008 08:38 PM
by Peo Sjoblom[_2_] Go to last post
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...
December 1st, 2003 04:55 PM
by Don Guillett Go to last post
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...
April 14th, 2010 04:34 PM
by excelrookie Go to last post
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...
July 28th, 2006 12:59 PM
by FunkySquid Go to last post
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,...
October 11th, 2008 05:27 AM
by Robert Blass Go to last post
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 Go to last post
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...
August 1st, 2006 03:38 AM
by Mirish26 Go to last post
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 Go to last post
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...
November 16th, 2006 02:23 PM
by Leo Heuser Go to last post
5 66
Post New Thread


Display Options
Showing threads 1141 to 1160 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.