Logical Test: Text Against Number 01-05-10

Can anyone provide insight into how Excel treats this type of test? For 
example, why does Excel return TRUE when we have ="a">2 but FALSE when ="a"<2 
(or any other number for that matter).

Thanks.
0
Utf
1/5/2010 10:46:02 PM
excel.worksheet.functions 4936 articles. 2 followers. Follow

2 Replies
721 Views

Similar Articles

[PageSpeed] 46

That's the way it is treated. Any kind of text is larger than the largest 
number. 
Any worth? hit the YES below
-- 
Max
Singapore
--- 
"rslaughter5" wrote:
> Can anyone provide insight into how Excel treats this type of test? For 
> example, why does Excel return TRUE when we have ="a">2 but FALSE when ="a"<2 
> (or any other number for that matter).
> 
> Thanks.
0
Utf
1/5/2010 10:53:02 PM
We went through this routine just a few days ago, on 12/31/2009.

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.worksheet.functions&tid=80af82fa-d9f8-48a9-9105-059eb3b7e6f0&cat=&lang=en&cr=US&sloc=en-us&p=1

Well, that was LAST year...


"Max" wrote:

> That's the way it is treated. Any kind of text is larger than the largest 
> number. 
> Any worth? hit the YES below
> -- 
> Max
> Singapore
> --- 
> "rslaughter5" wrote:
> > Can anyone provide insight into how Excel treats this type of test? For 
> > example, why does Excel return TRUE when we have ="a">2 but FALSE when ="a"<2 
> > (or any other number for that matter).
> > 
> > Thanks.
0
Utf
1/5/2010 11:23:01 PM
Reply:

Similar Artilces:

Create sequence number for table
Hi, I have a table with a Title field, comment field and a Sequence field. I would like code to sort the table by Title and then fill in the Sequence field based on the order of the records. The first record would have a sequence number of 1, the second record a 2, etc. Can someone help me with code to do this? Thanks in advance. "Phillip" <Phillip@discussions.microsoft.com> wrote in message news:432342F6-AD55-405B-8CDF-43414FBE421D@microsoft.com... > Hi, > I have a table with a Title field, comment field and a Sequence field. I > would like ...

Exporting email with atachment to text file
I would lke to have a backup of all my email in a pure text form. Many years ago I used Netscape email, and the entire mail file was pur text; attachments followed the message and were encoded in base64. I could always retrieve my email (with a little effort) by cuting and pasting, and using uuencode to retrieve the binary form of the attachment. Is there any way to do this in Outlook? I have recently encountered difficulties with different versions of Outook at home and work, so would like to avoid problems like this in the future by having a purely text email file. TIA <dtshedd@yah...

Rich Text / Plain Text. Error message
Hello Folks Every time I send an email, I get a window telling me that the email I am sending is in Rich Text format ((HTML) and asking me whether I wish to proceed by sendng in HTML, sending Plain Text or canceling. This is regardless of whether I am sending a simple attachment (Excel file a picture) even without any text. I have also just deleted my old account and re-set it up again. Please can you tell me how to avoid this message in the future? Looking forward to your answer in anticipation. Georgie Girl Isn't there a "Don't show me this again" ...

Listbox contains check box, small image icon and text
I would like to implement a list control in which every row contains check box, small image icon and text. how can I do it? Are there any sample codes? -- Nothing impossible, Nothing sure This will be a good start: http://www.codeproject.com/listctrl/ ----- Ajay Kalra ajaykalra@yahoo.com "NianHawk" <NianHawk@hotmail.com.invalid> wrote in message news:C43782D7-9D80-4F74-92EC-05E47983291E@microsoft.com... > I would like to implement a list control in which every row contains check > box, small image icon and text. how can I do it? Are there any sample codes? Dont k...

If-Then logics
Hi, I have a work sheet with numbers in 'Column A'. In 'Column B' I wish to get the following output: If column A is < 3000 then give me '1'; If column B is >5000 then give me '3'; if column A is >3000 but <5000 then give me '2'. Kindly help. Thanks Rumneet "Rum" wrote: > I have a work sheet with numbers in 'Column A'. > In 'Column B' I wish to get the following output: > If column A is < 3000 then give me '1'; > If column B is >5000 then give me '3'; > if...

Context Menu w/Popup missing initial menu text
Hello. I've been trying to find the answer to this on my own, but it's just not getting me anywhere. I've put in a context menu with a popup. Problem is, I can't get the first menu to display, but I can get the contents of the popup to show up. Here's the code I'm working with. BOOL CGUISnoopView::OnNotify(WPARAM wParam, LPARAM lParam, LRESULT* pResult) { CGUISnoopDoc* pDoc = GetDocument(); ASSERT_VALID(pDoc); if((((NMHDR*)lParam)->code ==NM_RCLICK)&&m_pGrid->GetFocusCell().row>0) { CMenu menu; VERIFY(menu.LoadMenu(IDR_POP_MENU)); CPoint pt;...

How to make ListBox refresh an item's text when the item object is changed?
class SomeClass { ... public override string ToSting { .... return different values according to its state. } } in the form's code SomeClass s = new SomeClass(); MyListbox.Items.Add(s); If I add it like that, the Listbox will use ToString() method to display the SomeClass. But the problem is when the SomeClass's inner state has changed and therefore ToString() value is changed, the Listbox doesn't reflect the change automatically. What could be the best clean solution? The only way I can think of is not to add the SomeClass directly, but add its ToStrin...

Text box reference a cell
I have a text box that I want to be equal to a cell. I posted a similar problem yetsreday about colors in two objects, but now I need the syntax for textboxes. Here is what I have so far: ActiveSheet.Shapes("Text1").Selection.Characters.Text = Sheets("COLORS").Range("C9").Text but it is having a problem with the syntax before the = sign. The text box is protected, so I was trying to avoid selecting the object. Hi Drawing toolbar textbox ? No code needed. Just select the textbox, and enter in Excel's formula field =COLORS!C9 HTH. Best wishes Harald...

Testing #3
I have never done this before cool huh ...

IF THEN LOGIC
Can you have a cell return a value based on another cell's input. Ex: If I enter the year 2004 in a specific cell then I want another cell to display the date 12/01/03 or some other date or value that I would pre-determine. Hi =IF(A1=2004,DATE(2003,12,1),"") -- Regards Frank Kabel Frankfurt, Germany "flotowntiger" <flotowntiger@discussions.microsoft.com> schrieb im Newsbeitrag news:B0DE4A33-E000-4468-AD96-309CE5D16E7D@microsoft.com... > Can you have a cell return a value based on another cell's input. Ex: If I > enter the year 2004 in a specific cel...

TEST SUBJ
TEST SUBJTEST SUBJTEST SUBJ ---JJ OK PASSED "mr. test" <no.spam@at.all> �������/�������� � �������� ���������: news:eITGSRL7DHA.2760@TK2MSFTNGP09.phx.gbl... > TEST SUBJTEST SUBJTEST SUBJ > ---JJ "Mr. Tester" <nospam@at.all> �������/�������� � �������� ���������: news:#qwBXTL7DHA.2088@TK2MSFTNGP10.phx.gbl... > OK PASSED > "mr. test" <no.spam@at.all> �������/�������� � �������� ���������: > news:eITGSRL7DHA.2760@TK2MSFTNGP09.phx.gbl... > > TEST SUBJTEST SUBJTEST SUBJ > > ---JJ > > ...

Concatenated text and Leban's Rich Text Control
Greetings All, I was wondering if anyone has run across the problem I'm having with concatenating rtf control contents and line returns. I am using Steven Leban's rich text tool in Access 2007 (as Microsoft's integrated rich text control is pretty much useless if you need to manipulate its contents) (Steven's tool is excellent). I am trying to insert new text into the middle of a rich text field, after formating it as needed, however, I've noticed that the rich text box inserts a line return at the end of my inserted text. I have searched around and have read that rich t...

Publisher 2003
Im trying to find out how to update certain textboxes (if that's what they really are) automatically. If you notice when you open a template and insert a new title, Certain boxes on the following pages automatically contain the SAME TEXT that you inserted for the title. Is there a way to do this in OTHER AREAS, for instance, I have a newsletter that will be published monthly there are 6 areas for articles, I have a small table of contents on the first page (its not formated as a TOC just a table with Titles and Page numbers) What I want to do is have those Titles automatically update wh...

IF THEN logic
Sample Data: A B C D E F G CID IID Concerns Interests Contact first timers Identifier TestData 1 1 Building Fellowshi NO U65286929 a 2 4 Tips for Meeting sp b 1 3 Building Opportuniti NO L35069718 a What i want to do is: if column G has an "a" then count column A if it has a 1 in it if column G has an "b" then count column A if it has a 2 in it etc. Seprate the data as first choice and second choice. =SUMPRODUCT(((G2:G200="a&quo...

Insert Bookmarked text
I use Word as the default composer in Outlook. I have a button in Word that, using VBA code, will insert into the active document the contents of a certain bookmark found in another Word document. Here is the essence of the VBA code: Selection.InsertFile FileName:="MyDocName.doc", Range:="Address" In 'regular' Word, the process works just fine, and the text found in bookmark 'Address' is properly inserted. But in Outlook, the command results in the entire document "MyDocName.doc" being inserted as an attachment to the message. Is there any wa...

Entering Text and Date
I need a macro that will enter some text "Uploaded" and the date and time in this format "The text" date time such as Uploaded 04/19/07 12:42 PM. I don't want this time to change after it is entered" Can any one help? Herschel , Sub EnterUpload() ActiveCell.Value = "Uploaded " & Format(Now, "mm/dd/yy h:mm AM/PM") End Sub HTH, Bernie MS Excel MVP "Herschel Lawhorn" <Herschel Lawhorn@discussions.microsoft.com> wrote in message news:79E4EA03-2757-45AA-BD52-6E2553483265@microsoft.com... >I need a macro that will enter...

Sorting numbers into ranges i.e 0-1000,1001-2000 and getting count
Please help, I need to sort the following type cost apple 800 banana 1000 cherry 1500 banana 1050 banana 600 cherry 2500 apple 0 so that it sorts by type and then does count between ranges 0-1000 1001-2000, 2001-3000 i.e type 0-1000 1001-2000 2001-3000 apple banana "with a count here " cherry thanks mik -- Message posted from http://www.ExcelForum.com Hi one way: 1. Add a helper column to show your type. e.g. enter the following in column C / cell C1: =MAX(INT((B1-1)/1000),0)*1000 & " - " & (MAX(INT((B1-1)/1000),0)+1)*1000 and ...

Visio 2003
Visio 4, 5, 2000 and 2002 could automagically create great drawings (flow-charts) from text-files. Visio 2003 professional does not recognize the text-files my VC6 application creates :-( I there an available another not so hard technique my application can use to let Visio create my simple drawings? ; ex2_visio_import.csv Template, "Audit Diagram.vst" Shape,"1","Terminator","Start",,,,,,, Shape,"2","I/O","Some kind of input",,,,,,, Shape,"3","Decision","Test the input",,,,,,, Shape,"4&q...

test #5
...

Removing text #3
Is there anyway i can remove unwanted text and numbers from samples below Almuraad(IRE) 11 Blythe Knight(IRE) 34 Course and Dist winner Ecomium(IRE) 174 Distance winnerBeaten Favourite Echo of Light 25 Khyber Kim 36 and just leave the names ie: Almuraad(IRE), Khyber Kim etc. Any help will be welcomed. Hi! Here's one way assuming all entries have some numerical digits in them: Entered as an array using the key combo of CTRL,SHIFT,ENTER: =LEFT(A1,MATCH(1,(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))>47)*(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))<58),0)-...

Showing Significance Testing in Bubble Charts
We are preparing a bubble chart in which the x-axis shows scores from a survey, the y-axis shows relative importance, and the z-dimension shows the percentage point change in the score from the previous period. We have set the default color of the bubbles to grey (which means no significant change), and would like to make the significant changes colored in red (negative) or green (positive). We have already done the stat testing, and can mark the significance testing with a -1 (negatively significant), 0 (insignificant), and +1 (positively significant). We would like to be able to autom...

Label cell size changes when text direction changed in Word?
When making labels, the cell size changes when text direction is changed. I would like to have text read vertically - to label spline of binders. Selecting text direction changes the cell size so that it does not match the size of the sticky back labels. It results in text running off edges of label. I am using label sheet 6466. So, I would like to: MOIP C H A P T E R 2 but it progresseively moves off sticky back label centers as more labels made. Thanks! It sounds as if you need to change the ori...

A question of concept/logic
Hello folks, I would really appreciate your help on the programming logic of the following example: Let's say you have an invitees table with Invitees_ID and Invitees_Names Assuming that you have another table this time with Events_ID and _Name. Now I would like to be able to select invitees, some of them, and invite them to q selected event. Which logic should I use: - Make a third table with gathered Invitees_ID and Events_ID? - Make a table for each events' year so that it can last in the future? Any correction/info will be greatly appreciated :) Have a nice day P.S. sorry a...

lookup function 01-26-10
how can I set up a lookup that will insert jpegs into a cell range. The jpegs are currently listed in Windows photo gallery Check out http://www.mcgimpsey.com/excel/lookuppics.html -- Jacob "spark" wrote: > how can I set up a lookup that will insert jpegs into a cell range. The > jpegs are currently listed in Windows photo gallery ...

text not wrapping in column
I have an Excel spread sheet with columns of wrapped text. At a certain point, the text stops wrapping. If I try to shrink to fit, the text disappears. Any ideas? ...