Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Not to be pedantic but len(S1) is preferable to S1<"".
Excel uses what are known as Pascal strings. With Pascal strings, the length of the string is stored at the beginning of the string. So for long strings, len() doesn't need to walk the length of the string for the comparison. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF statements | Excel Discussion (Misc queries) | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
If Statements | Excel Discussion (Misc queries) | |||
If... Then statements | Excel Discussion (Misc queries) | |||
using if statements | Excel Worksheet Functions |