How to avoid GUI mangling formula with less-than symbol?

joeu2004

Well-known Member
Joined
Mar 2, 2014
Messages
2,979
Office Version
  1. 2010
Platform
  1. Windows
I can enter the following formula just fine:

=STDEV(IF(A1:A40000<=E3,IF(A1:A40000>E4,C1:C40000)))

But when I try to enter it as follows ("lt" stands for the less-than symbol):

=STDEV(IF(E4 lt A1:A40000,IF(A1:A40000<=E3,C1:C40000)))

the GUI mangles the formula, truncating it to "=STDEV(IF(E4".

That happens even when the formula is wrapped with CODE tags.

How can I type the less-than symbol in that context without the line being mangled?

I tried put spaces around the less-than symbol, to no avail.
 

Some videos you may like

starl

Administrator
Joined
Aug 16, 2002
Messages
5,969
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. MacOS
=stdev(if(e4 < a1:a40000,if(a1:a40000<=e3,c1:c40000)))

if you put spaces around it, it will appear properly
 

joeu2004

Well-known Member
Joined
Mar 2, 2014
Messages
2,979
Office Version
  1. 2010
Platform
  1. Windows
=stdev(if(e4 < a1:a40000,if(a1:a40000<=e3,c1:c40000)))

if you put spaces around it, it will appear properly

I wrote: "I tried put[ting] spaces around the less-than symbol, to no avail".

Odd that it's working now -- even without the surrounding spaces (!). :confused:

Some differences:
- You entered lowercase; I entered uppercase.
- I entered the faulty text in the Advanced view, not the original Reply With Quote view.
- Sometimes the error was not visible until I did Preview Post.
- I am using Firefox 19. Don't know what browser and revision you use.
- [EDIT] I was using the GUI in the Excel Questions forum. This is a different forum. Different editor behavior?

Doing all of the following in the Advanced view, Preview Post after each one....

Copy-and-paste your text:
=stdev(if(e4 < a1:a40000,if(a1:a40000<=e3,c1:c40000)))

Copy-and-paste your text, change to uppercase:
=STDEV(IF(E4 < A1:A40000,IF(A1:A40000<=E3,C1:C40000)))

Copy-and-paste line above, remove spaces:
=STDEV(IF(E4<A1:A40000,IF(A1:A40000<=E3,C1:C40000)))

Enter text from scratch without spaces:
=STDEV(IF(E4<A1:A40000,IF(A1:A40000<=E3,C1:C40000)))

Copy-and-paste line above (also did not work before):
=STDEV(IF(E4<A1:A40000,IF(A1:A40000<=E3,C1:C40000)))

All looks good before Submit. [EDIT] All still looks good after Submit.
 
Last edited:

starl

Administrator
Joined
Aug 16, 2002
Messages
5,969
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. MacOS
Yes, I saw that you said it didn't work with the spaces.. but since I know it does, I figured if I showed it working, you might try again.

I am using FireFox 32.0.2
I have used both the Quick Reply and Advanced editor.
Interesting that the case changed since i copy/pasted your text and just changed the red text to the < symbol.
HTML code is off in this particular forum. If you look at the very bottom of the page, you will see HTML code is off.
It is on in only some forums. It is on in the Test Forum and you can test there - I have added a new post where you can see the symbol does work with spaces around it (I copy/pasted the version you copy/pasted). http://www.mrexcel.com/forum/test-here/806704-less-than-symbol-testing.html#post3944038
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,926
Office Version
  1. 365
Platform
  1. Windows
(Tracy, I saw - and replied to - your thread in the Test Here forum before I saw this thread, so I'll repeat here, & add a bit more..)

1. It is only the lack of a space after the < sign that is a problem.
eg This works fine without space before
=STDEV(IF(E4< A1:A40000,IF(A1:A40000<=E3,C1:C40000)))

2. The lack of a space is only a problem at all if the < is immediately followed by a letter.
eg These work fine without spaces
=STDEV(IF(E4<$A1:$A40000,IF(A1:A40000<=E3,C1:C40000)))
=IF(A1<4,2,1)

3. If you really wanted your formula to appear with a letter immediately after the < sign, then in your post, replace the offending < sign with <
You can't test that in this forum, but try it in the Test Here forum.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,125
Messages
5,599,856
Members
414,342
Latest member
K Darrell Smith

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top