Secret formulas

[XiniX]

There are secret, undocumented formulas.
I know 2 of them, DATEDIF and REGISTERID. Are there any more of those hidden secrets?

Thanks

[ This Message was edited by: XiniX on 2002-05-26 01:24 ]

[Aladin Akyurek]

On 2002-05-26 01:23, XiniX wrote:
There are secret, undocumented formulas.
I know 2 of them, DATEDIF and REGISTERID. Are there any more of those hidden secrets?

Thanks

[ This Message was edited by: XiniX on 2002-05-26 01:24 ]

Both functions, DATEDIF and REGISTER.ID, are not "secret" in Excel 2000. They are described in the Help file.

[Jack in the UK]

I dont know of any hidden or secret formulas, else why have them at all.

If you mean UDF one of my fav ideas, then YES kinda secret in taht the use might not no they are there, but wuld have had to open the sheet yes to macros prior.

UDF as such are easy to find with a keen eye in the use of the formula wizard.

Cnat see any point in having bits you cant use.

[XiniX]

Aladin,I use office XP, datedif and registerid don't showup in Help in XP...


So there are not hidden debugging features/formulas in XP?


[ This Message was edited by: XiniX on 2002-05-26 02:13 ]

[Aladin Akyurek]

I use office XP, datedif and registerid don't showup in Help in XP...

XP is a later version than 2000. I wouldn't expect that MS did not use the 2000 Help file as source for XP.

Is your XP a Dutch version? If so, lets wait if someone can confirm your observation in the English version.


So there are not hidden debugging features/formulas in XP?

I don't believe so.

PS. DATEDIF, SUMIF, and like are called 'functions', not 'formulas' in proper terminology. Formulas are things that you build using one or more worksheet functions and/or user-defined functions (UDF's).

[Jay Petrulis]

Excel 2000 is the only version to document the functions.

I have never used REGISTER.ID, but DATEDIF has been available in previous versions (Excel 97 for sure), but it only had Help support in Excel 2000 and was removed from XP. Nobody knows exactly why.

[XiniX]

Jay: It is supported in XP, but undocumented.
Aladin: i got indeed office xp dutch...
I know the difference between formulas and functions, but i didnot know the word to translate though.
I am still making a udf to translate the english formulas etc into another language.
I got some code already to translate from English to Dutch (or any other language).

See the next message please.

(maybe this is very difficult for you native English users to test this though)




[ This Message was edited by: XiniX on 2002-05-26 08:23 ]

[XiniX]

Here is the code....

Public Sub Dutch()
Dim Tekst As String
With Application
.EnableEvents = False
.ScreenUpdating = False
End With
With ActiveCell
On Error GoTo ErrorLine
Tekst = Cells(.Row - 1, .Column).Value
.Formula = Text
.Value = "'" & .FormulaLocal
End With
With Application
.EnableEvents = True
.ScreenUpdating = True
End With
Exit Sub
ErrorLine:
MsgBox "No translation?", vbOKOnly, ""
End Sub




This will translate the formulas from the previous row into Dutch

[XiniX]

And i got a udf as well to translate from English to Dutch

Public Function English(Cell As Range)
English = Cell.Formula
End Function

when the formula resides in A1, you type in A2 the following: =English(A1)


regards XiniX

[Ian Mac]

I've just check the English version of XP and
REGISTER.ID is in the helpfiles but only under the Answer Wizard not in the Index
but DATEDIF isn't in either

Curiouser and curiouser, said Alice.