-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
--isnumber???
- Thread starter cmefly
- Start date
just_jon
Legend
- Joined
- Sep 3, 2002
- Messages
- 10,473
The -- was brought here from ?Harlan Grove? via Aladin (hope I'm right) and coerces numeric results from formulas which would not normally yield them. At least, I think that's what I remember... Hey, don't trust me, haven't had a full cuppa joe, yet.
Upvote
0
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Jon is right.
Double -- is a coercer like +0, *1, that is, they force Excel to convert numbers stored as text and logical values into numbers. So...
=--TRUE --> 1
=TRUE+0 --> 1
=TRUE*1 --> 1
By the way, -- and +0 are equally fast and both faster than *1.
If you wish, you can change...
--(ISNUMBER(...))
to
ISNUMBER(...)+0
Double -- is a coercer like +0, *1, that is, they force Excel to convert numbers stored as text and logical values into numbers. So...
=--TRUE --> 1
=TRUE+0 --> 1
=TRUE*1 --> 1
By the way, -- and +0 are equally fast and both faster than *1.
If you wish, you can change...
--(ISNUMBER(...))
to
ISNUMBER(...)+0
Upvote
0
